Tracking Time in my Spreadsheet
Hi,
It depends how your dates are stored and these look suspicious with the @
sign in the middle. However on the assumption your dates are stored using a
'normal' type of format then its simple subtraction:-
=laterdate-earlierdate
with the cell formatted with [hh]:mm
Mike
"Moist" wrote:
Hi,
Would someone be so kind to advise me of the formular required to track the
hours passed between two dates/time?
i.e
Start Date and Time = 01/01/07 @ 06:00 hrs
End Date & Time = 03/01/07 @ 12:30 hrs
= 54.5 hrs
Thanks in advance for your help.
Gary
|