ExcelBanter - Subtracting hours from time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Subtracting hours from time (https://www.excelbanter.com/excel-discussion-misc-queries/112879-subtracting-hours-time.html)

Kerry O''''Brien

Subtracting hours from time

Is there any formula that allows me to subtract (2) hours from 8:00 am, for
example?

Thanks.

Marcelo

Subtracting hours from time

hi Kerry

assuming that the 08:00 is on a2

=a2-time(2,0,0)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

"Kerry O''''Brien" escreveu:

Is there any formula that allows me to subtract (2) hours from 8:00 am, for
example?

Thanks.

All times are GMT +1. The time now is 07:42 AM.