P
PCERM
I am trying to set up a time management sheet for workers on Flexi Time but
cannot work out how to show times in a negative format. All employees would
normally work 7 hours per day and when they work 7.5 hours the sheet displays
30 mins extra adding up over the week. However when the time is less than
seven all that is diplayed is #########. Although the final column still
calculates the total sum the display is not what I am looking for. Can
anyone help please?
cannot work out how to show times in a negative format. All employees would
normally work 7 hours per day and when they work 7.5 hours the sheet displays
30 mins extra adding up over the week. However when the time is less than
seven all that is diplayed is #########. Although the final column still
calculates the total sum the display is not what I am looking for. Can
anyone help please?