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
==========
