LinkBack URL
About LinkBacks
Dear,
Need to LAMBDA formula to recursive through all the time values in cells A2 & B2. And print each duration result in C2. Please help thanks in advance.
time cal.png
Need a formula to time difference
Dear,
Need to LAMBDA formula to recursive through all the time values in cells A2 & B2. And print each duration result in C2. Please help thanks in advance.
time cal.png
Last edited by anavarathan; 12-08-2023 at 08:12 AM.
If you are looking for a LAMBDA function that means that you are not using Excel 2007 as your profile states - please update this so contributors know what version of Excel you are using.
Pete
Next time, please upload an Excel file, instead of a non-editable picture of one. It saves us (me) having to recreate what you have right in front of you.
=TEXTJOIN(CHAR(10),,TEXT(TEXTSPLIT(B2,,CHAR(10))-TEXTSPLIT(A2,,CHAR(10)),"hh:mm:ss"))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Sorry updated. Thanks
Thank you.
Thank youOriginally Posted by Glenn Kennedy
You're welcome. Thanks for letting us know that you got an answer.
Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks