R
Richardisa1
I am making a spreadsheet to record employees flexible working hours.
The standard week is 37 hours and sometimes people will work less tha
37 hours one week and work more the following week to make up th
difference. Therefore at the end of a week there could be a minus valu
to carry forward to the following week.
I have tried to use time values but Excel will not accept time as
minus value. I could use decimal time thus 08:30 am would be 8.50 bu
I would rather use time format. Can anyone suggest a way round th
problem.
Any help/suggestions would be appreciated
The standard week is 37 hours and sometimes people will work less tha
37 hours one week and work more the following week to make up th
difference. Therefore at the end of a week there could be a minus valu
to carry forward to the following week.
I have tried to use time values but Excel will not accept time as
minus value. I could use decimal time thus 08:30 am would be 8.50 bu
I would rather use time format. Can anyone suggest a way round th
problem.
Any help/suggestions would be appreciated