Subtract hours from known datetime.

P

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?
 
N

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?
|
 
Top