ExcelBanter - formula for negative time durations

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula for negative time durations (https://www.excelbanter.com/excel-worksheet-functions/183971-formula-negative-time-durations.html)

DAZA

formula for negative time durations

I am looking for a formula that will produce negative time durations...

Pete_UK

formula for negative time durations

If you switch over to the 1904 date system (Tools | Options |
Calculation tab) then you can represent negative times. Be wary,
though, that this can mess up dates within your workbook if they were
entered in the default 1900 system.

Hope this helps.

Pete

On Apr 16, 5:31*pm, DAZA wrote:
I am looking for a formula that will produce negative time durations...

All times are GMT +1. The time now is 01:10 AM.