MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time Calculation By Total Hours, Mins


Posted by Matthew on January 01, 2002 10:31 AM

How can I calculate the total time taken (by hours) for a task to be completed if I need to key in the start date/time and the end date/time?

Example : Cell A1 = 12/10/2001 6:00am
B1 = 12/11/2001 9:30am
C1 = 27:30 Hours/Mins


Posted by Aladin Akyurek on January 01, 2002 11:18 AM

Matthew --

In C1 enter:

=B1-A1 or better:

=MOD(B1-A1,1)

and custom format C1 as [h]:mm.

Aladin

============

Posted by Matthew on January 02, 2002 7:17 AM

Aladin,

Thanks a lot and Happy New Year!

Matthew

==========