Jan 02 2022 01:32 AM
hi, im trying to work out total scheduled hours less sick hours, holiday hours, furloughed hours, public holiday hours, annual leave hours, walk to work hours
Hours Scheduled d2
Less
Hours Sick e2
hours furloughed f2
hours annual leave g2
Hours public holiday h2
Hours walk to work i2
Actual Hours Worked j2
Thanks
Jan 02 2022 01:52 AM
I may only guess how your data looks like. If assume as
it works. Here elapsed time format [hh]:mm is applied.