Subtracting hours from time

  • Thread starter Kerry O''''Brien
  • Start date
K

Kerry O''''Brien

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

Thanks.
 
M

Marcelo

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