Hi,
In D6 I have this time value: 0d 02:00:00h - Which translates to 2 hours and 0 seconds
In D7 I have this time value: 3d 16:09:23h - Which translates to 3 days, 16 hours, 9 minutes and 23 seconds
I need a formula for D8 to give me an output of the the time difference from D6 to D7. So it should give me a result of: 3d 14:09:23h
Thanks!!!!
Hi,
Please upload your spreadsheet with desired result once.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hi,
Try the following formula in D8, this is assuming that the dates are in TEXT format:
See the attached file.
Please Login or Register to view this content.
Worked like a charm. Thanks and WOW that was fast! Adding Rep.
You are welcome
If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.
=TEXT(LEFT(D7,SEARCH("d",D7)-1)+MID(D7,4,8)-LEFT(D6,SEARCH("d",D6)-1)-MID(D6,4,8),"d\d hh:mm:ss\h")
Try thisPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
=TEXT(LEFT(D7,SEARCH("d",D7)-1)+MID(D7,SEARCH("d",D7)+2,8)-LEFT(D6,SEARCH("d",D6)-1)-MID(D6,SEARCH("d",D6)+2,8),"d\d hh:mm:ss\h")
Try this one
above formula will not work if days contain more than 9 (This also work for 30 day of difference not more than that)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks