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!
Give this formula a try...Originally Posted by zorro
=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")
Last edited by Rick Rothstein; 08-19-2016 at 07:24 PM.
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.
Posting Permissions
Reply With Quote
Bookmarks