Calculating # Of hours between two given times
Posted by Remus Garraway on January 28, 2002 3:56 PM
I have a start time in one cell and end time in another how do i calculate the number of hours between the two times. They are in hhmmss format e.g (11:03:24 AM)start time and end time(11:14:37 AM)
Any help is greatly appreciated .
Regards,
Remus
Posted by Aladin Akyurek on January 28, 2002 4:02 PM
=B1+(B1 < A1)-A1
where B1 houses the end time and A1 the start time
Custom format the cell of the formula as [h]:mm
=========
Posted by remus Garraway on January 28, 2002 4:18 PM
:Thanks !!! How do I sum up the number of hours now
Posted by Aladin Akyurek on January 28, 2002 4:29 PM
Just SUM them: =SUM(C1:C10).
Again the cell of the sum formula must be custom-formatted as [h]:mm.
=========
Posted by Liviu P on January 28, 2002 4:44 PM
Help! hours between two given times
Hi
How can I make a button to paste the current time in a cell?
Any help is greatly appreciated .
Thanks,
Liviu
Posted by Remus Garraway on January 29, 2002 5:34 AM
:That works fine . Much appreciated . I din't format the calculating properly hence the question.
Again thank you for the help!!!!!
Remus
