Forum Discussion
How to display negative amount of time
Hi everyone, I’m making a worktime sheet for my husband. I’m not having any trouble deducting his start and stop times, but I made a column for the amount of hours he’s supposed to work, and a c...
Maybe, for the formula, you could use absolute value (ABS function), but then use conditional formatting to test if he worked less than what he was supposed to and apply a custom number format of
-h:mm
or something similar. So, the cell contents will still be positive, but the formatting will display it as negative? If you need totals, then you would have to use sumif functions to test if the actual time is <=> the expected time and net the results.
Maybe someone else will have a better suggestion. I can't say I've ever tried to work with negative time values.
-h:mm
or something similar. So, the cell contents will still be positive, but the formatting will display it as negative? If you need totals, then you would have to use sumif functions to test if the actual time is <=> the expected time and net the results.
Maybe someone else will have a better suggestion. I can't say I've ever tried to work with negative time values.