behest
asked on
Subtract one hour from cells with m/d/yyyy h:mm
I have data provided in one time zone and need to subtract one hour from the cell contents to adjust to another time zone. When I attempt to correct using a formula with the cell address - 1, it subtracts from the day.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome. :-)
ASKER