Date and Time Calculation in Hours and Minutes

[melmart]

I am trying to calculate time elapsed between to date/times. I would like the elapsed time to be in hours. Below is an example:

Email Time: 2/25/2007 10:58 AM
Response Time: 2/27/2007 9:23 AM


Any suggestions?

 

[HalfAce]

Hello melmart, welcome to the board.
Assuming your start time (Email time) is in B1 and your end time (response time) is in B2,
Format your formula cell as Custom [h]:mm and you can use this:

=(B2+(B2<B1)-B1)

This translates to:

=(End time+(End time<Start time)-Start time)

Hope it helps.

 

[melmart]

It worked! Thank you!

 

[HalfAce]

It worked!

I know. . .

You're most welcome.