Formulas

[Simon]

Can Anyone Help!!!!!

In cell A1 I have a time (eg. 6:15), In cell A2 I want to
do the sum A1 - 5 hours, Does anyone know the correct
formula to use

 

[Frank Kabel]

Hi Simon
enter in A2:
=A1-TIME(5,0,0)
or
=A1-5/24
for both formulas: Format A2 as time