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
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")
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thanks, however no luck it gives #VALUE!
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
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Perfect, thanks for all your help, its working as expected.
Bookmarks