Subtract hours from known datetime.

  • Thread starter Thread starter pmclinn
  • Start date Start date
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?
 
=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?
|
 
Back
Top