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

Try this:

=A1 - 3/24

as time is stored internally as fractions of a 24-hour day. If the 3
is in a cell, like B1:

=A1 - B1/24

Format appropriately.

Hope this helps.

Pete

On Sep 29, 7:04*pm, 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

=cell-time(3,0,0)

or

=cell-(3/24)



--


Regards,


Peo Sjoblom

"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

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

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

Hi,

Suppose you want to do the subtraction in cell A2 with the original value in
A1, one formula would be:
=A1-3/24

Or if you want to enter the number of hours to add or subtract in A2 and
have the result display in A3, enter in A3
=A1-A2/24

--
Thanks,
Shane Devenshire


"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

On Sep 29, 11:21*am, ShaneDevenshire
wrote:
Hi,

Suppose you want to do the subtraction in cell A2 with the original value in
A1, one formula would be:
=A1-3/24

Or if you want to enter the number of hours to add or subtract in A2 and
have the result display in A3, enter in A3
=A1-A2/24

--
Thanks,
Shane Devenshire



"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- Hide quoted text -

- Show quoted text -

Thanks everybody! Steve