Overlaping of worktimes
ABCDEFStart of overtimeEnd of overtimeTotal overtimeStart of Stand-byEnd of Stand-byTotal Standby0:001:3027:0019:00127:0020:00137:0019:00020:0023:50419:000:0015:008:3047:0019:0010 7:0019:0012
Hello,
above is example sheet that I use for workers. This is part with standby and overtime, and I need to decrease time of Total Standby with hours of Total overtime only if times overlap, like in table above (if worker is on overtime for 30 and more minutes it is counted as full hour). Overtime can be any hour between 0 – 24h because worker can be called at any time for work in case of emergency (firefighters), but standby is entered only in this way (each row represent new day):
DEFStart of Stand-byEnd of Stand-byTotal Standby19:000:0050:007:0077:0019:0012
ABCDEFStart of overtimeEnd of overtimeTotal overtimeStart of Stand-byEnd of Stand-byTotal Standby0:001:3027:0019:00127:0020:00137:0019:00020:0023:50419:000:0015:008:3047:0019:0010 7:0019:0012 Hello,above is example sheet that I use for workers. This is part with standby and overtime, and I need to decrease time of Total Standby with hours of Total overtime only if times overlap, like in table above (if worker is on overtime for 30 and more minutes it is counted as full hour). Overtime can be any hour between 0 – 24h because worker can be called at any time for work in case of emergency (firefighters), but standby is entered only in this way (each row represent new day):DEFStart of Stand-byEnd of Stand-byTotal Standby19:000:0050:007:0077:0019:0012 Read More
