topic Re: time stamp subtract hours in Visualization and Usability

time stamp subtract hours

124psu — Sat, 16 Nov 2024 02:47:05 GMT

I want to subtract 4 hours from the now() function to show the EST time zone.

=timestamp(now() - time(4))

This actually does nothing and gives me the same thing as = now().

Anyone have any tips/ideas on how to simply subtract 4 from the now() function?

salezian — Fri, 09 Aug 2019 07:07:46 GMT

Did you try this:

=Timestamp(num(now())-4/24)

Marcin.

124psu — Thu, 15 Aug 2019 15:49:02 GMT

Thanks very much. Didn't realize I had to divide by 24.