ExcelBanter - Minus time

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

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

- - Minus time (https://www.excelbanter.com/excel-discussion-misc-queries/126839-minus-time.html)

Tufail

Minus time

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

Stefi

Minus time

You are welcome! Thanks for the feedback!
Stefi

€žTufail€ ezt Ã*rta:

Thank you very much.

"Stefi" wrote:

=A1-1/24

Regards,
Stefi

€žTufail€ ezt Ã*rta:

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

Tufail

Minus time

Thank you very much.

"Stefi" wrote:

=A1-1/24

Regards,
Stefi

€žTufail€ ezt Ã*rta:

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

All times are GMT +1. The time now is 08:48 AM.