negative time

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Negative time

Negative time

resolvedResolved · Medium Priority · Version 365

Chris has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Intermediate course
Excel Dashboards for Business Intelligence course
Advanced Excel Dashboards course
Excel PowerPivot course
Excel Advanced - Formulas & Functions course
Excel Charting course

Negative time

Hi,

having issue with this sheet, when the time becomes negative it doesn't like it so we have added an IF formula to say put it into a positive if its negative, now struggling to calculate bought forward plus new time to leave us with a new balance carried forward using another IF should the value state its 'owing' or 'overtime'. Do you have any ideas or clever tricks?

Thanks

Chris

RE: Negative time

Hi Chris

Can you email a copy/sample of what you're trying to do to info@stl-training.co.uk

Thanks

Dennis

RE: Negative time

Hi Chris

Working with negative dates is a limitation of the default 1900 date system used by Excel. Changing the date system to the 1904 system you will be able to perform negative calcuations with dates.

See the linked articles for an example.

https://www.extendoffice.com/documents/excel/1423-excel-display-show-negative-time.html

Hope this helps.

Regards

Dennis

Wed 6 Nov 2019: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips


Server loaded in 0.13 secs.