Calculate time

[BrendanDixon]

Hi All,

I would like to be able to calculate the no of hours from a specific date and time to another date and time. Only thing is that

Start Date = D15
Start Time = E15
End Date = F15
End Time = G15

I cannot find a function or any info on how to do this, can somone please help me?

 

[Desu Nota from Columbus]

=((f15-d15)*24)+((g15-e15)*24)

Gives the total number of hours. Format As Number.

 

[T. Valko]

Hi All,

I would like to be able to calculate the no of hours from a specific date and time to another date and time. Only thing is that

Start Date = D15
Start Time = E15
End Date = F15
End Time = G15

I cannot find a function or any info on how to do this, can somone please help me?

Try this...

=(F15+G15)-(D15+E15)

Format as [h]:mm

 

[Desu Nota from Columbus]

The difference between T.Valko's answer and mine is the format and units of the answer.


Say you are comparing a start date of December 24th at 12:00 Noon, and End Date of December 25th at 12:00 Noon.

We know the answer of this is exactly 24 hours. My formula generates 24.0 hrs , T.Valko's generates 24:00 (hh:mm)

All a matter of how you want your answer and what are you going to do with it?

If the anwer were 24 hours and 30 minutes, mine would be 24.5 and his would be 24:30.

Just giving you a heads up.

 

[BrendanDixon]

Hi,

I Like a combination of both. I insert the time in minutes but instead of putting ":" I just put "." i.e. I put 9.30 instead of 9:30

This works fine with the formula =((F15-D15)*24)+(G15-E15)

Except when the start time minutes are larger than the end time minutes
i.e. start 7.45 and finish 8.30 I get 0.85 instead of 0.45

Do you know how to fix this?