# 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  Reply With Quote

2. Hi,
plz see the attachment.  Reply With Quote

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""""")  Reply With Quote

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""""")  Reply With Quote

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  Reply With Quote

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  Reply With Quote

#### Posting Permissions

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