Calcultating times

[maiden_moon]

I work for a company that is in a time zone 2 hours ahead of me. I
receve my schedual in this format:

Date Start Time End Time
Sunday, August 20, 2006 1:00:00 AM 2:00:00 AM

But this is in the wrong time zone for me... is there a way to enter
this into excel and get the correct time and date for me?

 

[Michael Bednarek]

I work for a company that is in a time zone 2 hours ahead of me. I
receve my schedual in this format:

Date Start Time End Time
Sunday, August 20, 2006 1:00:00 AM 2:00:00 AM

But this is in the wrong time zone for me... is there a way to enter
this into excel and get the correct time and date for me?

Adjust the time values by n/24 where n is the hourly offset to your
timezone. E.g.:
A1: 01:00
A2: =A1+2/24 (03:00)
or use the TIME function; for details, see Help on "TIME Worksheet
Function".