Calculate Difference Between Start Date Time And End Date Time

[zorro]

Please help to subtract the start time minus end time , it will help me to calculate the actual time taken.



formattedClosedDate
formattedStartTime


Aug 17, 2016, 7:28:14 AM
Aug 17, 2016, 6:34:53 AM

[Excel Fox]

Try this

=TEXT(DATEVALUE(LEFT(A1,12))+TIMEVALUE(MID(A1,14,4 0))-DATEVALUE(LEFT(B1,12))-TIMEVALUE(MID(B1,14,40)),"HH:MM:SS")

[zorro]

Thanks, however no luck it gives #VALUE!

[Rick Rothstein]

Thanks, however no luck it gives #VALUE!
Give this formula a try...

=A1-B1

and format the cell with the time format of your choice. If that does not work, then see if this one does instead...

=TEXT(SUBSTITUTE(A1,",","",2)-SUBSTITUTE(B1,",","",2),"hh:mm:ss")

[snb]

Please help the helpers to help you: post a sample workbook!

[zorro]

Sample file attached, please help.

[Admin]

Hi

Swap the cells in the formula.

=TEXT(SUBSTITUTE(B2,",","",2)-SUBSTITUTE(A2,",","",2),"hh:mm:ss")

HTH

[zorro]

Perfect, thanks for all your help, its working as expected.