98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Negative time
Negative time
Resolved · Medium Priority · Version 365
Tue 29 Oct 2019, 13:38Delegate Chris said...
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
Wed 30 Oct 2019, 12:03Trainer Dennis said...
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
Wed 30 Oct 2019, 14:39Trainer Dennis said...
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Paste with Live Preview in Excel 2010Did you know you can preview what you are about to paste? Here's how to do it. |
