T
That's Confidential
I am trying to introduce minuses into my spreadsheet.
I have the amount of hours someone should work per day in a cell, ie. 6:00.
However I also have a column which take into account if that person did not
turn up. If that is the case, I want that cell to minus the amount of hours
someone should have worked from zero, so in this case I end up with -6:00,
so as this can be deducted at a later stage!
eg:
Hours to be worked Hours worked Short Time
4:00 4:00
0:00
6:00
0:00 -6:00
Any ideas? If that isn't possible, when working out total hours worked,
maybe I could just leave short time figure as a positive and so, do "hours
worked" - "hours to be worked"
I have the amount of hours someone should work per day in a cell, ie. 6:00.
However I also have a column which take into account if that person did not
turn up. If that is the case, I want that cell to minus the amount of hours
someone should have worked from zero, so in this case I end up with -6:00,
so as this can be deducted at a later stage!
eg:
Hours to be worked Hours worked Short Time
4:00 4:00
0:00
6:00
0:00 -6:00
Any ideas? If that isn't possible, when working out total hours worked,
maybe I could just leave short time figure as a positive and so, do "hours
worked" - "hours to be worked"