I am trying to find out the difference between the current time and 5PM. I tried numerous variations and I just can't make sense of the results I am getting.
Lets say current time is 15:36 (3:34 PM)
When I run this formula
(TIMENOW() - TIMEVALUE("00:17:00.000"))
I get the following:
Given the fact that time time is 15:36 and I want to discover how long till 17:00 (5PM) I would expect one of these:
I can't make sense of this. Is this a fraction of a day, milliseconds....a decimal value?