formula for negative time durations

P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How enter time DURATIONS mm:ss (not clock times), then sum? 1
Sumproduct formula 6
Red cell for negative numbers in Excel 1
SUMIF Help 1
Pivot table: sum of durations 2
look up problem 3
SUM formula for adding time durations 4
Linking Equations to Highlights 2

Top