Hi guys,
Just a quick question on how to get a predicted Clock Out time for the week with 60.5 hours MAX.
Column1 is the total so far in the week.
Clock In Time is Todays clock in time.
If the Recommended Clock out time is 12 hours or more away, have it display a text.
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1060"]
<tbody>[TR]
[TD="class: xl66, width: 100"]Employee ID[/TD]
[TD="class: xl67, width: 223"]Employee Name[/TD]
[TD="class: xl67, width: 247"]Manager[/TD]
[TD="class: xl68, width: 87"]Time[/TD]
[TD="class: xl68, width: 87"]Column1[/TD]
[TD="class: xl68, width: 104"]Clock In Time[/TD]
[TD="class: xl67, width: 212"]Recommended Clock Out Time[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 1060"]
<tbody>[TR]
[TD="class: xl66, width: 100, align: right"]blank[/TD]
[TD="class: xl67, width: 223"]blank[/TD]
[TD="class: xl67, width: 247"]XX[/TD]
[TD="class: xl68, width: 87, align: right"]14:04:00[/TD]
[TD="class: xl69, width: 87, align: right"]46:35[/TD]
[TD="class: xl68, width: 104, align: right"]07:22:00[/TD]
[TD="class: xl69, width: 212"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advanced
Just a quick question on how to get a predicted Clock Out time for the week with 60.5 hours MAX.
Column1 is the total so far in the week.
Clock In Time is Todays clock in time.
If the Recommended Clock out time is 12 hours or more away, have it display a text.
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1060"]
<tbody>[TR]
[TD="class: xl66, width: 100"]Employee ID[/TD]
[TD="class: xl67, width: 223"]Employee Name[/TD]
[TD="class: xl67, width: 247"]Manager[/TD]
[TD="class: xl68, width: 87"]Time[/TD]
[TD="class: xl68, width: 87"]Column1[/TD]
[TD="class: xl68, width: 104"]Clock In Time[/TD]
[TD="class: xl67, width: 212"]Recommended Clock Out Time[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 1060"]
<tbody>[TR]
[TD="class: xl66, width: 100, align: right"]blank[/TD]
[TD="class: xl67, width: 223"]blank[/TD]
[TD="class: xl67, width: 247"]XX[/TD]
[TD="class: xl68, width: 87, align: right"]14:04:00[/TD]
[TD="class: xl69, width: 87, align: right"]46:35[/TD]
[TD="class: xl68, width: 104, align: right"]07:22:00[/TD]
[TD="class: xl69, width: 212"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advanced
Last edited: