Complex IF and Date/Time Confusion

[firehousetk]

I can't seem to get these formulas to work well together. If I input the time into J23 by hand, then L23 works properly, but as-is, J23 is incorrect. Also, I25 works in a test document I created, but fails to work properly in this finished document.

What are your thought? I'm simply lost.

(Attached)Where as:

H23 is the date and time the document was created (pulled from a macro)
I23 is the date pulled from H23
J23 is the time pulled from H23
K23 is the day of the week expressed as a number
I25 is a formula to calculate a due date that is I23 + condition of I25 formula

[6StringJazzer]

I am not sure what answer you expect, so I'm not sure exactly what's wrong, but I have an educated guess.

J23 is the time pulled from H23

J23 is not the time, it is the same value as H23 simply formatted to look like a time. If you want just the time then you need this:

=H23-INT(H23)

The same is true for the date, but that part may not be causing you any problems. But to get just the date in I23 use this:

=INT(H23)

[firehousetk]

Yes, that worked great for the time and date. I'm now getting the correct value L23. Now, I have to sort out the mess of a formula that is I25! Thanks very much!

[arthurbr]

Another way to extract time =MOD(H23,1)