Our computers are controlled by a central server on pacific time which is lock down and we can not change. . We are on central time which is a one hour difference. When we make spread sheets in excel, is always looks at the system time to calculate dates and time, which are incorrect for our area. I need a simple VBA code to basically subtract 1 hour from the system time to reflect the proper times on our excel spreadsheets.