TIMENOW() subtraction
One thing to keep in mind is that TIMENOW() returns a time value in milliseconds since midnight GMT, not a formatted time string. That's why you're seeing a large number instead of hours or minutes.If your goal is to find the time remaining until 5 PM, you need to subtract the current time from the target time, not…
Answered Jun 16, 2026 · 1.3K Views Read answer →