Subtract time from Cell

[mnhim001]

Hi,

I really need some help to subtract 5 minutes from another cell, but that cell has Date and time value and the resulting cell must keep the same date but minus 5 minutes.

Current Cell A1= 9/1/21 14:22
New Output A2= 9/1/21 14:17

I am not sure of the formula used, any help appreciated. Thank you.

 

[Toadstool]

Hi Mnhim001,

TIME will work

Book1
	I	J
10	9/1/2021 14:22	9/1/2021 14:17
Sheet1

Cell Formulas
Range	Formula
J10	J10	=I10-TIME(0,5,0)