Re: Calculate Date Differences: Time in & Time Out
you can just subtract the two values.
if 12/11/2010 10:09 is in A1
12/12/2010 11:00 is in A2
the formula would just be =A2-A1
The trick is in how the result is formatted. It may come back as 1.035416667 or when I did it, the default format in the cell with the formula displayed the result as 1/1/1900 0:51.
To get it to display 24:51, you just have to change the format of the cell with the formula.
Set it to a custom format of [hh]:mm and it will display as you want it to.
If you don't know how to do a custom format. Right click on the cell. Choose format cells
Select the Number tab
Choose Custom from the Category.
On the right below where it says Type:, input the [hh]:mm and click OK.