P
peter_cologne
There have been many posts on this subject but I cannot find one which
answers this question:
I have a (Office XP) spreadsheet which records an employee's working time.
Our company operates flexi-time and employees have to work an average of 7:20
per day. On days when they work longer than that, there is a positive
adjustment to their running flexi-time balance. On days when when they work
less, there is a negative adjustment. The flexi-time balance itself can be
either positive or negative (within certain limits).
My sheet FUNCTIONS perfectly but will not DISPLAY any negative values,
either for the daily adjustments or the running balance. In such cases, the
cell is filled with "#######" so that the employee cannot see the real value.
Anyone know how to make Excel display the negative time values which it is
(apparently) storing correctly?
Grateful for any suggestions,
Pete
answers this question:
I have a (Office XP) spreadsheet which records an employee's working time.
Our company operates flexi-time and employees have to work an average of 7:20
per day. On days when they work longer than that, there is a positive
adjustment to their running flexi-time balance. On days when when they work
less, there is a negative adjustment. The flexi-time balance itself can be
either positive or negative (within certain limits).
My sheet FUNCTIONS perfectly but will not DISPLAY any negative values,
either for the daily adjustments or the running balance. In such cases, the
cell is filled with "#######" so that the employee cannot see the real value.
Anyone know how to make Excel display the negative time values which it is
(apparently) storing correctly?
Grateful for any suggestions,
Pete