C
CrankyLemming
This is a bit difficult to explain.
I am trying to set up a timesheet which covers a 13 week span. Because
we have employees working a jobshare basis (most do 2 day weeks
followed by 3 day weeks), full-timers and part-timers, I have set up a
sheet where variables can be input in a header row as follows: Initial
balance, Week 1 total hours, number of days worked week 1, week 2
total hours, number of days worked week 2.
No problem so far. However, this is being done as a replacement for an
old system, and some people willbegin the sheet in deficit, say
-(minus)1 hour. I can't seem to get a formula which can calculate with
'negative time.' Does anyone have any ideas?
So say one person starts with an initial balance of -1 hour. Week 1
they are contracted to work 24 hours over 3 days, and in week 2 it is
18 hours over 2 days. Then 24 in 3, 18 in 2, etc.
If, in week 1, they worked exactly 24 hours, how can I get Excel to
show a cumulative total of -1 hour?
I appreciate I may not have explained this very well, but can happily
supply the worksheet to show what I mean.
Yhanks in advance
Steve
I am trying to set up a timesheet which covers a 13 week span. Because
we have employees working a jobshare basis (most do 2 day weeks
followed by 3 day weeks), full-timers and part-timers, I have set up a
sheet where variables can be input in a header row as follows: Initial
balance, Week 1 total hours, number of days worked week 1, week 2
total hours, number of days worked week 2.
No problem so far. However, this is being done as a replacement for an
old system, and some people willbegin the sheet in deficit, say
-(minus)1 hour. I can't seem to get a formula which can calculate with
'negative time.' Does anyone have any ideas?
So say one person starts with an initial balance of -1 hour. Week 1
they are contracted to work 24 hours over 3 days, and in week 2 it is
18 hours over 2 days. Then 24 in 3, 18 in 2, etc.
If, in week 1, they worked exactly 24 hours, how can I get Excel to
show a cumulative total of -1 hour?
I appreciate I may not have explained this very well, but can happily
supply the worksheet to show what I mean.
Yhanks in advance
Steve