Dates and Time

[tready29483]

Hi,

I'm trying to figure out how to calculate hours between dates.

IE: Start Date : 9/1/2006 1:15PM
End Date : 9/10/2006 12:45 AM

I'd like to know how many hours are in that time frame. Can anyone help me??

[jtp]

Try this. Say

A1 = Start Date
A2 = End Date

=(A2-A1)*24

HTH

[tready29483]

That didn't work. All I get is ####. It stats that #### is displayed when the answer is a negitive date/time.

[Dav]

The answer for the above post should be formated as a number, dates are numbers, 1 being a whole day so subtracting one from the other and x by 24 will give you the hours

as would a2-a1 formmated as [h] but this would be full hours. However you can not have a negative time or date, which is causing your error. Is the start after the finish?

Regards

Dav

[tready29483]

The start date is 9/1/2006 1:15 AM and the end date is 9/10/2006 12:45 PM. I need to be able to calculate the number of hours between those two times.

[tready29483]

I'm guessing no one can help me with this?? If not, please let me know.

[oldchippy]

The start date is 9/1/2006 1:15 AM and the end date is 9/10/2006 12:45 PM. I need to be able to calculate the number of hours between those two times.

Hi tready29483,

Formula is with start in A1 and end in B1

=B1-A1 formatted to [hh]:ss

oldchippy