Date Problem

[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

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.