time stamp subtract hours

[124psu]

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 · Accepted solution]

Hi

Did you try this:

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

KR

Marcin.

[124psu]

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