I need to convert a date and a time from PST to EST, how can I do

[KTharle]

I've tried subtracting the hours, but it keeps subtracting from the date.
I've tried subtracting just from the time and that doesn't work either.

 

[Ron Coderre]

Any chance you could share your formulas?
What you have and what you've tried (that didn't work)

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[KTharle]

I am new to excel still, so I've only tried "=C3-5,0,0" using the cell C3 as
the date and time and also as just the time.

 

[Ron Coderre]

Try this:
=C3-TIME(3,,)

or...this:
=C3-3/24

To Excel "hours" are decimal fractions of a day:
Noon = 0.5.....12/24
6 AM = 0.25....6/24

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)