Date Problem

H

Himu

We are currently on Day-light Savings time, si there any
way I can have Eastern Timing on my cells, without having
to change my time/date properties in my desktop?

Please help! Thank you
 
N

Norman Harker

Hi Himu!

Deduct an hour from all times?

You could do it in one block by:

Put the following in an empty cell:

=1/24
Copy that cell

Select all the cells to be changed
Edit > Paste Special > Subtract > OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top