Hours represented in decimal amounts
Posted by Michael Rudon on April 28, 2001 7:27 AM
I need to take the difference in two times of the day and show a result in hours and hundedths as opposed to hours and minutes. Thanks for any help.
Posted by Mark W. on April 28, 2001 12:36 PM
=("12:20"-"9:00")*24
Format the cell containing this formula as 0.00 .
Substitute your own times or cell references that
contain time values.
