View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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