Calculate time difference between two dates

N

naveed

New member
Joined
Jul 1, 2015
Messages
5
Reaction score
0
Points
0
Hi everyone, I am unable to calculate the time difference between two dates.

Here's what i am trying to calculate

Start Date Start TimeEnd DateEnd Time
26-Jun-1510:29 PM27-Jun-155: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
 
Hi,
plz see the attachment.
 

Attachments

  • Test.xlsx
    8.9 KB · Views: 6
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""""")
 
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


sambit said:
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""""")
Click to expand...
 
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
 

Attachments

  • Test.xlsx
    33.7 KB · Views: 4
Hi

Thanks alot buddy, i really appreciate that.

sambit said:
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
Click to expand...
 
You must log in or register to reply here.
Back
Top