Hi,

With a correctly formatted date/time in A1 try this.

=A1-TIME(3,0,0)

Mike

"SteveR" wrote:

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