• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

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.
0
behest
Asked:
behest
  • 2
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
To subtract one hour from a cell (assuming data is in cell A1 in this example)
=A1-(1/24)


-Glenn
0
 
behestAuthor Commented:
Thank you so much!!!!
0
 
Glenn RayExcel VBA DeveloperCommented:
You're welcome. :-)
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now