Try this:

A1 = 09/30/08 16:00

=A1-TIME(3,0,0)

Format as desired

--
Biff
Microsoft Excel MVP


"SteveR" wrote in message
...
I have a cell formatted as mm/dd/yy hh:mm and I need to subract 3
hours from this value.
example: 09/30/08 16:00 result should read as 09/30/08 13:00.
Thanks for any help.
Steve