Minus time
 

enter in B1
=A1 - TIME(1,0,0)

"Tufail" wrote:

hi,
i have in cell A1 current time and in cell B1 i want show minus 1hr from
current time so plz someone help me, thanks in advance.

A1 (C-Time) B1
16:00 15:00

Minus time
 

Pressing the rate this post button would be appreciated and helpful for other
people asking the same question.

"Tufail" wrote:

Thank you very much.

"Mike" wrote:

enter in B1
=A1 - TIME(1,0,0)

"Tufail" wrote:

hi,
i have in cell A1 current time and in cell B1 i want show minus 1hr from
current time so plz someone help me, thanks in advance.

A1 (C-Time) B1
16:00 15:00