Thread: Calculate time difference between two dates

1. Calculate time difference between two dates

Hi everyone, I am unable to calculate the time difference between two dates.

Here's what i am trying to calculate

 Start Date Start Time End Date End Time
 26-Jun-15 10:29 PM 27-Jun-15 5:09 AM

The formula used is : =((I36+J36)-(H36+G36))*24 The answer that i am getting 6.67 actually it should be 6.40...

Anyone knows how to correct this??

Thanks

2. Hi,
plz see the attachment.

3. Hi,
Assume
Start Date = A2
Start Time = B2
End Date = C2
End Time = D2
Try below formula in cell E2:
=INT((C2+D2)-(A2+B2))&TEXT((C2+D2)-(A2+B2),"h"":""m""""")

4. Hi

Hi my friend, that was awesome...so that problem is solved now, but how would i add the total time??

 8:05 010:15 08:35 010:29 08:03 5:45

Originally Posted by sambit
Hi,
Assume
Start Date = A2
Start Time = B2
End Date = C2
End Time = D2
Try below formula in cell E2:
=INT((C2+D2)-(A2+B2))&TEXT((C2+D2)-(A2+B2),"h"":""m""""")

5. Hi,
Try sum function. in which cell you get the total time, just change the format cell.

Press Ctrl+1

Go to custom then choose or type [h]:mm:ss

see the attachment

6. Hi

Thanks alot buddy, i really appreciate that.

Originally Posted by sambit
Hi,
Try sum function. in which cell you get the total time, just change the format cell.

Press Ctrl+1

Go to custom then choose or type [h]:mm:ss

see the attachment

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•