Hi,
I need to make B11 calculate the time passed from A11 ?
I attached a doc to explain better
Thanks
Hi,
I need to make B11 calculate the time passed from A11 ?
I attached a doc to explain better
Thanks
Please try at
B4 to get date time value from the text, custom format date time
=--(MID(A4,5,FIND(",",A4)-5)&LEFT(A4,3)&MID(A4,FIND(",",A4)+2,4))+LOOKUP(1,--TRIM(SUBSTITUTE(MID(A4,FIND(" ",A4),20),{"p","a"},{" PM"," AM"})))
C4 for the active time from now
Formula:Please Login or Register to view this content.
C4 formula did the trick, it's exactly what i was looking for.
You guys always rescue us.
Thanks a million
Happy to help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks