MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.