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!