Negative to Positive time

Mongee

New Member
Joined
Aug 1, 2017
Messages
1
Hi,

We have developed a timesheet for our staff that accrue PDO time and it all works perfectly, including when they go into negative PDO accrual time. However, once they go into negative PDO accrual time, then receive additional accruals to become positive PDO accrual time, the formula throws an error.
As you can see in the picture below.
[TABLE="width: 849"]
<tbody>[TR]
[TD="class: xl98, width: 79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Employee ID
[/TD]
[TD="class: xl99, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl210, width: 232, bgcolor: transparent"][/TD]
[TD="class: xl215, width: 14, bgcolor: transparent"][/TD]
[TD="class: xl216, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl216, width: 54, bgcolor: transparent"][/TD]
[TD="class: xl216, width: 59, bgcolor: transparent"][/TD]
[TD="class: xl217, width: 496, bgcolor: transparent, colspan: 12"][/TD]
[TD="class: xl218, width: 15, bgcolor: transparent"][/TD]
[TD="class: xl218, width: 54, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Surname
[/TD]
[TD="class: xl101, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl210, bgcolor: transparent"][/TD]
[TD="class: xl218, bgcolor: transparent"][/TD]
[TD="class: xl216, bgcolor: transparent"][/TD]
[TD="class: xl216, bgcolor: transparent"][/TD]
[TD="class: xl216, bgcolor: transparent"][/TD]
[TD="class: xl220, bgcolor: transparent, colspan: 6"][/TD]
[TD="class: xl221, bgcolor: transparent"][/TD]
[TD="class: xl219, bgcolor: transparent"][/TD]
[TD="class: xl218, bgcolor: transparent"][/TD]
[TD="class: xl219, bgcolor: transparent"][/TD]
[TD="class: xl221, bgcolor: transparent"][/TD]
[TD="class: xl218, bgcolor: transparent"][/TD]
[TD="class: xl218, bgcolor: transparent"][/TD]
[TD="class: xl218, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 2"]Given Name(s)
[/TD]
[TD="class: xl210, bgcolor: transparent"][/TD]
[TD="class: xl211, width: 470, bgcolor: transparent, colspan: 10"]EMPLOYEES INTERIM AWARD (WSE)
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Work Unit
[/TD]
[TD="class: xl101, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl210, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]N
[/TD]
[TD="class: xl152, bgcolor: transparent"]O
[/TD]
[TD="class: xl65, bgcolor: transparent"]P
[/TD]
[TD="class: xl151, bgcolor: transparent"]Q
[/TD]
[TD="class: xl65, bgcolor: transparent"]R
[/TD]
[TD="class: xl66, bgcolor: transparent"]S
[/TD]
[TD="class: xl65, bgcolor: transparent"]T
[/TD]
[TD="class: xl65, bgcolor: transparent"]U
[/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 2"]Flexi Start Period
[/TD]
[TD="class: xl140, bgcolor: transparent"]28-May-2021
[/TD]
[TD="class: xl202, width: 69, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , colspan: 2"]PDO Last pd (+/-)
[/TD]
[TD="class: xl198, bgcolor: transparent"]+
[/TD]
[TD="class: xl200, bgcolor: transparent"]5:36
[/TD]
[TD="class: xl206, width: 69, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] , colspan: 2"]TOIL Last pd (+/-)
[/TD]
[TD="class: xl198, bgcolor: transparent"]+
[/TD]
[TD="class: xl200, bgcolor: transparent"]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 2"]Flexi End Period
[/TD]
[TD="class: xl142, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]24-Jun-2021
[/TD]
[/TR]
[TR]
[TD="class: xl103, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl104, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl103, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl115, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl110, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl195, width: 54, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Leave Type
[/TD]
[TD="class: xl111, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 4, align: center"]Standard
[/TD]
[TD="class: xl103, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 2"]Hrs Worked
[/TD]
[TD="class: xl115, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl158, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , colspan: 2"]PDO
[/TD]
[TD="class: xl105, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 2"]PDO
[/TD]
[TD="class: xl171, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] , colspan: 2"]TOIL
[/TD]
[TD="class: xl147, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 2"]TOIL
[/TD]
[/TR]
[TR]
[TD="class: xl105, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl106, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl105, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl105, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl116, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Daily
[/TD]
[TD="class: xl103, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl115, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl115, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl117, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl118, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 2"]Adjust
[/TD]
[TD="class: xl120, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: center"]Hours
[/TD]
[TD="class: xl158, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] , colspan: 2"]Accrual
[/TD]
[TD="class: xl105, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 2"]Cumulative
[/TD]
[TD="class: xl171, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] , colspan: 2"]Accrual
[/TD]
[TD="class: xl147, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , colspan: 2"]Cumulative
[/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Date
[/TD]
[TD="class: xl107, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Day
[/TD]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Comments
[/TD]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl121, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Hours
[/TD]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Arrive
[/TD]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Lunch On
[/TD]
[TD="class: xl100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Lunch Off
[/TD]
[TD="class: xl107, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Depart
[/TD]
[TD="class: xl122, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+/-
[/TD]
[TD="class: xl121, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl123, width: 53, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: center"]Worked
[/TD]
[TD="class: xl160, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+/-
[/TD]
[TD="class: xl154, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "][/TD]
[TD="class: xl122, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+/-
[/TD]
[TD="class: xl161, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl173, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+/-
[/TD]
[TD="class: xl146, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "][/TD]
[TD="class: xl148, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+/-
[/TD]
[TD="class: xl174, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[/TR]
[TR]
[TD="class: xl108, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]28-May-2021
[/TD]
[TD="class: xl141, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Friday
[/TD]
[TD="class: xl109, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl132, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl124, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl124, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl126, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl127, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl162, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl133, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl163, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]5:36
[/TD]
[TD="class: xl162, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl133, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl163, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl108, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]29-May-2021
[/TD]
[TD="class: xl107, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Saturday
[/TD]
[TD="class: xl109, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl132, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl124, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl124, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl126, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl127, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl164, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl133, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl129, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl163, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]5:36
[/TD]
[TD="class: xl164, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl131, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl129, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl175, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]30-May-2021
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Sunday
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl192, bgcolor: #EAEAEA"][/TD]
[TD="class: xl177, bgcolor: transparent"]7:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:00
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]16:00
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]8:00
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]0:24
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]6:00
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]31-May-2021
[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Monday
[/TD]
[TD="class: xl71, bgcolor: transparent"]HSR rep training
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl192, bgcolor: #EAEAEA"]TRN
[/TD]
[TD="class: xl177, bgcolor: transparent"]8:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:00
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]16:30
[/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]7:30
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]0:24
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]6:24
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]01-Jun-2021
[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Tuesday
[/TD]
[TD="class: xl143, bgcolor: transparent"]HSR rep training
[/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl193, bgcolor: #EAEAEA"]TRN
[/TD]
[TD="class: xl177, bgcolor: transparent"]8:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:00
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]16:30
[/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]7:30
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]0:24
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]6:48
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]02-Jun-2021
[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Wednesday
[/TD]
[TD="class: xl150, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl193, bgcolor: #EAEAEA"][/TD]
[TD="class: xl177, bgcolor: transparent"]7:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:00
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]16:00
[/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]8:00
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]0:24
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]7:12
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]03-Jun-2021
[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Thursday
[/TD]
[TD="class: xl156, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl192, bgcolor: #EAEAEA"]PDO
[/TD]
[TD="class: xl177, bgcolor: transparent"][/TD]
[TD="class: xl177, bgcolor: transparent"][/TD]
[TD="class: xl177, bgcolor: transparent"][/TD]
[TD="class: xl177, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]-
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]7:36
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]-
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:24
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Totals - Week 1
[/TD]
[TD="class: xl94, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl89, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]40:00
[/TD]
[TD="class: xl182, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl84, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl84, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl84, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl84, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl85, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]31:00
[/TD]
[TD="class: xl165, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , colspan: 2"]Week End
[/TD]
[TD="class: xl91, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]-
[/TD]
[TD="class: xl166, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:24
[/TD]
[TD="class: xl165, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , colspan: 2"]Week End
[/TD]
[TD="class: xl91, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl166, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl108, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]04-Jun-2021
[/TD]
[TD="class: xl107, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Friday
[/TD]
[TD="class: xl109, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl132, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl124, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl183, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl126, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl127, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl162, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl133, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]-
[/TD]
[TD="class: xl163, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]FALSE
[/TD]
[TD="class: xl164, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl131, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl149, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl163, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl108, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]05-Jun-2021
[/TD]
[TD="class: xl107, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]Saturday
[/TD]
[TD="class: xl109, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl132, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl124, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl183, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl125, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl126, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl127, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "][/TD]
[TD="class: xl128, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl164, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl133, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl129, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]-
[/TD]
[TD="class: xl163, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]FALSE
[/TD]
[TD="class: xl164, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl131, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[TD="class: xl130, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]+
[/TD]
[TD="class: xl175, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]06-Jun-2021
[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Sunday
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl192, bgcolor: #EAEAEA"][/TD]
[TD="class: xl177, bgcolor: transparent"]8:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:00
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]17:00
[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]8:00
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]0:24
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]-
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]FALSE
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]07-Jun-2021
[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Monday
[/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl192, bgcolor: #EAEAEA"][/TD]
[TD="class: xl177, bgcolor: transparent"]7:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:00
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]16:00
[/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]8:00
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]0:24
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]-
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]FALSE
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]08-Jun-2021
[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Tuesday
[/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl193, bgcolor: #EAEAEA"][/TD]
[TD="class: xl177, bgcolor: transparent"]7:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:00
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]16:00
[/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]8:00
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]0:24
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]-
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]FALSE
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]09-Jun-2021
[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Wednesday
[/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl193, bgcolor: #EAEAEA"][/TD]
[TD="class: xl177, bgcolor: transparent"]7:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:00
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]16:00
[/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]8:00
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]0:24
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]-
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]FALSE
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]10-Jun-2021
[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Thursday
[/TD]
[TD="class: xl143, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent"]8:00
[/TD]
[TD="class: xl192, bgcolor: #EAEAEA"][/TD]
[TD="class: xl177, bgcolor: transparent"]7:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:00
[/TD]
[TD="class: xl177, bgcolor: transparent"]13:30
[/TD]
[TD="class: xl177, bgcolor: transparent"]16:00
[/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]8:00
[/TD]
[TD="class: xl190, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]+
[/TD]
[TD="class: xl189, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E4DFEC]#E4DFEC[/URL] "]0:24
[/TD]
[TD="class: xl184, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]-
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]FALSE
[/TD]
[TD="class: xl191, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]+
[/TD]
[TD="class: xl188, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAEEF3]#DAEEF3[/URL] "]0:00
[/TD]
[TD="class: xl185, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl186, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]Totals - Week 2
[/TD]
[TD="class: xl94, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl89, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]40:00
[/TD]
[TD="class: xl182, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl84, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl84, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl84, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl84, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl85, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "][/TD]
[TD="class: xl93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]40:00
[/TD]
[TD="class: xl165, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , colspan: 2"]Week End
[/TD]
[TD="class: xl91, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]-
[/TD]
[TD="class: xl166, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]FALSE
[/TD]
[TD="class: xl165, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , colspan: 2"]Week End
[/TD]
[TD="class: xl91, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]+
[/TD]
[TD="class: xl166, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] "]0:00
[/TD]
[/TR]
</tbody>[/TABLE]

The formula we've used is..

Cell M18 =IF((L18=0),((J18-I18)+(H18-G18)),IF((K18="+"),((J18-I18)+(H18-G18)+L18),IF(AND(K18="-",L18=E18),(L18-E18),IF((K18="-"),((J18-I18)+(H18-G18)-L18)))))

Cell N18 =IF(M18<$E18,"-",IF(M18>=$E18,"+"))

Cell O18 =IF(M18<e18,e18-m18,if(m18>E18,M18-E18,IF(M18=E18,0)))

Cell P18 =IF(AND($P17="+",$N18="+"),"+",IF(AND($P17="+",$N18="-"),IF($Q17>=$O18,"+","-"),IF(AND($P17="-",$N18="-"),"-",IF(AND($P17="-",$N18="+"),IF($O18>=$Q17,"+","-")))))

Cell Q18 =(IF(AND($P17="+",$N18="+"),$Q17+$O18,IF(AND($P17="+",$N18="-"),IF($Q17>=$O18,$Q17-$O18,$O18-$Q17),IF(AND($P17="-",$N18="-"),$Q17+$O18,IF(AND($P17="-",$N18="+"),IF($O18>=$Q17,(IF(($O18-$Q17)<0.001,0,$Q17-$O18))))))))

Cell R18 =IF(O18<$E18,"-",IF(O18>=$E18,"+"))

Cell S18 =IF(F18="PDO",0,(IF(AND(ISBLANK(F18),ISBLANK(G18),ISBLANK(L18)),0,(IF(ISBLANK(F18),IF(M18<e18,e18-m18,if(m18>E18,M18-E18,IF(M18=E18,0))),0)))))

Cell T18 =IF(AND($T16="+",$N18="+"),"+",IF(AND($T16="+",$N18="-"),IF($U16>=$O18,"+","-"),IF(AND($T16="-",$N18="-"),"-",IF(AND($T16="-",$N18="+"),IF($O18>=$U16,"+","-")))))

Cell U18 =IF(AND($T16="+",$R18="+"),$U16+$S18,IF(AND($T16="+",$R18="-"),IF($U16>=$S18,$U16-$S18,$S18-$U16),IF(AND($T16="-",$R18="-"),$U16+$S18,IF(AND($T16="-",$R18="+"),IF($S18>=$U16,$S18-$U16,$U16-$S18)))))


I really hope someone is able to help me fix the error when the staff go back to positive time after they have been in negative.

Thanks</e18,e18-m18,if(m18></e18,e18-m18,if(m18>
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Hi Mongee,

Welcome to the Forum.

I have not really looked at this very hard. I did however look at the red False in your graphic. Which if I counted correctly is Cell P18. When I looked at the formula in Cell P18, the part I highlighted in Red does not seem to make sense.


Cell P18 =IF(AND($P17="+",$N18="+"),"+",IF(AND($P17="+",$N18="-"),IF($Q17>=$O18,"+","-"),IF(AND($P17="-",$N18="-"),"-",IF(AND($P17="-",$N18="+"),IF($O18>=$Q17,"+","-")))))

That particular IF statement is supposed to be the "value if true" from the previous IF statement (in
blue).

Again, this was just a quick look, and at only one formula, but you may want to check it out...

I hope this helps.
 
Upvote 0
.
Where are you located and what kind of work do your employees do ?

I've never worked for anyone who let their employees go into negative PDO. Would love to give it a try ! :laugh:
 
Upvote 0

Forum statistics

Threads
1,223,229
Messages
6,170,881
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top