If you put (in B1)
=A1-TIME(0,3,0)
and format column B as a date that should work.
(or do you need it in Standard time even in the middle of summer, i.e. account for Daylight Savings)
If you put (in B1)
=A1-TIME(0,3,0)
and format column B as a date that should work.
(or do you need it in Standard time even in the middle of summer, i.e. account for Daylight Savings)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks