charleyw78
03-03-2006, 02:56 AM
Hi there,
This should be a simple question but i'm struggling. I am trying to develop a timesheet for my office. The staff member fills in start times and end times and the number of hours is calculated. This number is then compared against the total time expected to be worked and the difference carried over into the next week.
If someone does 35 hours when 37 is expected then i would like to be able to carry over -2 hours. Excel won't let me do this as it is seeing the number as a time not an integer.
Any ideas?
This should be a simple question but i'm struggling. I am trying to develop a timesheet for my office. The staff member fills in start times and end times and the number of hours is calculated. This number is then compared against the total time expected to be worked and the difference carried over into the next week.
If someone does 35 hours when 37 is expected then i would like to be able to carry over -2 hours. Excel won't let me do this as it is seeing the number as a time not an integer.
Any ideas?