Tracking Time in my Spreadsheet

[Moist]

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

 

[Mike H]

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

 

[OssieMac]

Hi Gary,

If the date and time are entered in the same cell as 01/01/07 06:00 then you
simply subtract one from the other.

If the date and time are entered in separate cells then add each date and
time and subtract one from the other.

Format the cell with the result to custom time format [h]:mm and it will
display in hours and minutes. (The square brackets around the h force it to
hours for the display.)

If you want the result to be in hours and decimal of an hour then multiply
the result by 24 and format the cell to numeric.

Example:
Cell A1 contains: 01/01/07 06:00
Cell B1 contains: 03/01/07 12:30
Formula in C1: =B1-A1 ( format cell C1 as [h]:mm )

Alternative formula in C1:
=(B1-A1)*24 ( format cell C1 as number with 1 or 2 decimal places )

 

[Moist]

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"?

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

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

 

[Mike H]

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

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"?

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

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