Calculating for Time Difference...BUT

[Miskondukt]

Ok, so I have a formula

Please Login or Register  to view this content.

that I want to modify to subtract three hours from and show a result as days only.

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

[easyexcelanswers]

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?

[Miskondukt]

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.

[easyexcelanswers]

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