Ta Da!! That did it.

But exactly what does the Int (f14/24) do?

"Toppers" wrote:

try:

=$I$64-TIME(F14,G14,H14)-INT(F14/24)

"ET902" wrote:

I am trying to show the date and time when I subtract hours:min from a date
and time. Currently the formula I am using is $I$64-TIME(F14,G14,H14) where
I64 contains the date and time, F14 is hours, G14 is minutes and H14 is
seconds. Everything works great until I get to 24 hours. The date reverts
back to the original date, but the time is correct. How do I get the date to
calculate correctly?