Subtract hours from known datetime.

[pmclinn]

If I have the timestamp column with values like 10/16/2006 13:00:00 and
I want to subtract 14 hours. What is the best way to do this using
excel?

 

[Niek Otten]

=A1-(14/24)

1 is a day, 1/24 is an hour

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| If I have the timestamp column with values like 10/16/2006 13:00:00 and
| I want to subtract 14 hours. What is the best way to do this using
| excel?
|