S
Steve
XL 2007
Iwant to have a 'simple' timesheet where a user types in their start
time, end time, lunch break etc and XL calcs the total number of hours
they've worked. And calcs against their contracted hours, to see if
they are in time credit or edbit.
The problem seems to be if they have worked less than their contracted
hours, XL displays #####'s if there's a negative number.
I realise it's something to do with the end time being before the
start time, and the 24-hour clock etc, but I can get so very close,
but not get it perfect. For example, my latest version does everyting
I want apart from dosplaying the 'Excess' (time they're in
credit/debit) as a negative if they've worked less hours. This then
screws-up the running total.
Help! Please!
Steve
start time end time total start lunch end lunch
lunch total Grand Total Excess R/Total
Iwant to have a 'simple' timesheet where a user types in their start
time, end time, lunch break etc and XL calcs the total number of hours
they've worked. And calcs against their contracted hours, to see if
they are in time credit or edbit.
The problem seems to be if they have worked less than their contracted
hours, XL displays #####'s if there's a negative number.
I realise it's something to do with the end time being before the
start time, and the 24-hour clock etc, but I can get so very close,
but not get it perfect. For example, my latest version does everyting
I want apart from dosplaying the 'Excess' (time they're in
credit/debit) as a negative if they've worked less hours. This then
screws-up the running total.
Help! Please!
Steve
start time end time total start lunch end lunch
lunch total Grand Total Excess R/Total