How to convert Now() to Eastern Standard Time

bradyboyy88

Well-known Member
Joined
Feb 25, 2015
Messages
553
Hi,

I have multiple users across the US using my application and I utilized the now() function. So is there way to convert all of these now() to eastern standard time because these time stamps are saved in my access database.

Thanks
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,103
Office Version
365
Platform
Windows
I believe that NOW() is dependent on your regional time settings (I am in the Eastern Time Zone), and NOW() returns the correct time.

So, if it returns something different for you, then your regional time settings is probably something other than Eastern Time, so you would just need to offset your time by that.

You can do that by adding/subtracting the difference in hours divided by 24, i.e.
=Now() + (hours/24)
or
=Now() - (hours/24)
where hours is the difference in hours between your regional settings and the Eastern time zone
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,096,428
Messages
5,450,367
Members
405,607
Latest member
griffindor2020

This Week's Hot Topics

Top