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


Format the cell containing this formula as 0.00 .
Substitute your own times or cell references that
contain time values.