Ok, so I have a formulathat I want to modify to subtract three hours from and show a result as days only.
=INT(W3-I3)&" days "&TEXT(W3-I3,"h"" hrs """)
Is there a way to modify this function to do so?
Thank you kindly gentleman.
Err, the important components:
Example I3 Cell value: 12/1/2013 13:15
Exmple W3 Cell value: 12/11/2013 12:23
Last edited by Miskondukt; 01-30-2014 at 03:44 PM.
you could use the following formula to show days only
=DATEDIF(W3,I3, "d")&" days" the result would be 10 days
which value did you want to take three hours from?
http://www.easyexcelanswers.com
Haha, nais handle (nickname). I need three hours removed from the W3 value, but the entry in that cell column is extracted (hence needing the formula to calc).
The suggestion you offered would give me the number of days, my current formula for this column is simply, "=DAY(W6-I6)." I need to subtract three hours (TZ difference) to calc the number of days in case it went from say, 15-14 days because of the hour difference (we have 24/7 service requests) and that difference is integral for a grading metric based on times intervals.
The catch is the column in question grades off of number of days, which still brings me back to if a three hour difference reduces that day value we need to ensure we have it calculating correctly.
the only way that I could figure to do it is insert a cell
=D4-$E$4 cell e4 would have 3:00:00 and D4 would be your original value
12/11/2013 12:23 3:00:00 12/11/2013 9:23
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks