Excel formula calculate difference in two datetimes, answer in hours and tenths (decimal)
Posted on 2011-09-15
How can I create a new column that contains the difference between two datetime values, with the answer expressed in hours and tenths-of-hours?
Begin Date (in A1) = 6/9/2011 12:04:00 PM
End Date (in B1) = 7/1/2011 12:15:00 PM
Hours Spent = B1 - A1
The answer is 528:11 when I custom-format it with [hh]:mm , but I need it to show as 528.2 (decimal format).
Thanks in advance!