以星期以为每周的第一天,按把相同周内工作时间最少的两天的工作时间跟星期六,星期天的工作时间对调!以月为单位计算(每月计算一次)
WEEK WNAME WDATE WHOUR WKDAY
---- ---------- ----------- ------ ------
14 A 2009-4-1 5.00 wed
14 A 2009-4-2 7.00 thu
14 A 2009-4-3 8.00 fri
14 A 2009-4-4 6.50 sat
14 A 2009-4-5 8.00 sun
15 A 2009-4-6 7.00 mon
15 A 2009-4-7 8.00 tue
15 A 2009-4-8 3.00 wed
15 A 2009-4-9 8.00 thu
15 A 2009-4-10 5.00 fri
15 A 2009-4-11 7.00 sat
15 A 2009-4-12 8.00 sun
16 A 2009-4-13 7.00 mon
16 A 2009-4-14 8.00 tue
16 A 2009-4-15 8.00 wed
14 B 2009-4-1 7.00 wed
14 B 2009-4-2 8.00 thu
14 B 2009-4-3 4.00 fri
14 B 2009-4-4 8.00 sat
14 B 2009-4-5 8.00 sun
WEEK WNAME WDATE WHOUR WKDAY
---- ---------- ----------- ------ ------
15 B 2009-4-6 6.00 mon
15 B 2009-4-7 8.00 tue
15 B 2009-4-8 6.00 wed
15 B 2009-4-9 3.00 thu
15 B 2009-4-10 7.00 fri
15 B 2009-4-11 8.00 sat
15 B 2009-4-12 5.00 sun
16 B 2009-4-13 8.00 mon
16 B 2009-4-14 5.00 tue
16 B 2009-4-15 8.00 wed
A中week 14 把4-1 和4-5日对调,星期六的whour少于其它whour不用对调。对调后结果为:
14 A 2009-4-1 8.00 wed
14 A 2009-4-5 5.00 sun
WEEK WNAME WDATE WHOUR WKDAY
---- ---------- ----------- ------ ------
14 A 2009-4-1 5.00 wed
14 A 2009-4-2 7.00 thu
14 A 2009-4-3 8.00 fri
14 A 2009-4-4 6.50 sat
14 A 2009-4-5 8.00 sun
15 A 2009-4-6 7.00 mon
15 A 2009-4-7 8.00 tue
15 A 2009-4-8 3.00 wed
15 A 2009-4-9 8.00 thu
15 A 2009-4-10 5.00 fri
15 A 2009-4-11 7.00 sat
15 A 2009-4-12 8.00 sun
16 A 2009-4-13 7.00 mon
16 A 2009-4-14 8.00 tue
16 A 2009-4-15 8.00 wed
14 B 2009-4-1 7.00 wed
14 B 2009-4-2 8.00 thu
14 B 2009-4-3 4.00 fri
14 B 2009-4-4 8.00 sat
14 B 2009-4-5 8.00 sun
WEEK WNAME WDATE WHOUR WKDAY
---- ---------- ----------- ------ ------
15 B 2009-4-6 6.00 mon
15 B 2009-4-7 8.00 tue
15 B 2009-4-8 6.00 wed
15 B 2009-4-9 3.00 thu
15 B 2009-4-10 7.00 fri
15 B 2009-4-11 8.00 sat
15 B 2009-4-12 5.00 sun
16 B 2009-4-13 8.00 mon
16 B 2009-4-14 5.00 tue
16 B 2009-4-15 8.00 wed
A中week 14 把4-1 和4-5日对调,星期六的whour少于其它whour不用对调。对调后结果为:
14 A 2009-4-1 8.00 wed
14 A 2009-4-5 5.00 sun
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货