Calculate Difference Between Start Date Time And End Date Time

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

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")

Thanks, however no luck it gives #VALUE!

Quote:

---

Originally Posted by zorro

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")

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

Sample file attached, please help.

Hi

Swap the cells in the formula.

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

HTH

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