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
