lest say you have 2 dates & times in A1 and B1

10/1/2007 22:00 in A1
31/1/2007 06:00 in B1

type =B1-A1 in another cell and right click that cell and then

Format Cells|Number|Custom and type in a custom formt of

[hh]:mm ensuring yopu remember the [] square brackets bit. Click OK

Mike


"Moist" wrote:

Hi Mike, thank yu for the propt response, buit I'm totaslly green when it
comes to spreadsheet, so caould you give me a litytle more advise.

I have altered my cell referncec to hh:mm in cells B3 & C3 and I would like
to see my results (to use the formulation you have advised) in cell D3, but
I'm unsure hiow to complete the formular "=laterdate-earlierdate"?





"Mike H" wrote:

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