Ok, so hopefully the table below explains the issue - the 38.00 in column Q is the problem. The issue seems to occur if I have a none on the hour start time with and try to add 30 minutes:
(HOUR(P2+TIME(0,30,0))+MINUTE(P2+TIME(0,30,0)))
[TABLE="class: grid, width: 700, align: center"]
<tbody>[TR]
[TD="align: center"]L
Start
[/TD]
[TD="align: center"]M
Finish[/TD]
[TD="align: center"]N
(Deduct 30' Lunch)[/TD]
[TD="align: center"]O
(Decimal Shift)[/TD]
[TD="align: center"]P
(T'Sheet Hours)
[/TD]
[TD]
[/TR]
[TR]
[TD="align: center"]07:00[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]8.50[/TD]
[TD="align: center"]8:30[/TD]
[TD="align: center"]9.00[/TD]
[/TR]
[TR]
[TD="align: center"]07:00[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]8.50[/TD]
[TD="align: center"]8:30[/TD]
[TD="align: center"]8.50[/TD]
[/TR]
[TR]
[TD="align: center"]07:30[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]8.00
[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]38.00[/TD]
[/TR]
[TR]
[TD="align: center"]07:30[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]8.00[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]8.00[/TD]
[/TR]
[TR]
[TD="align: center"]21:00[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]8.50[/TD]
[TD="align: center"]8:30[/TD]
[TD="align: center"]9.00[/TD]
[/TR]
[TR]
[TD="align: center"]21:00[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]8.50[/TD]
[TD="align: center"]8:30[/TD]
[TD="align: center"]8.50[/TD]
[/TR]
[TR]
[TD="align: center"]21:30[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]8.00[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]38.00[/TD]
[/TR]
[TR]
[TD="align: center"]21:30[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]8.00[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]8.00[/TD]
[/TR]
</tbody>[/TABLE]
O Column = P2*24
P Column = ((M2-L2+(M2<L2))-TIME(0,30,0))
Q Column = IF(N2="Y",(P2*24),(HOUR(P2+TIME(0,30,0))+MINUTE(P2+TIME(0,30,0))))
Thanks in advance folks.
(HOUR(P2+TIME(0,30,0))+MINUTE(P2+TIME(0,30,0)))
[TABLE="class: grid, width: 700, align: center"]
<tbody>[TR]
[TD="align: center"]L
Start
[/TD]
[TD="align: center"]M
Finish[/TD]
[TD="align: center"]N
(Deduct 30' Lunch)[/TD]
[TD="align: center"]O
(Decimal Shift)[/TD]
[TD="align: center"]P
(T'Sheet Hours)
[/TD]
[TD]
Q
(Invoice Qty)
[/TD](Invoice Qty)
[/TR]
[TR]
[TD="align: center"]07:00[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]8.50[/TD]
[TD="align: center"]8:30[/TD]
[TD="align: center"]9.00[/TD]
[/TR]
[TR]
[TD="align: center"]07:00[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]8.50[/TD]
[TD="align: center"]8:30[/TD]
[TD="align: center"]8.50[/TD]
[/TR]
[TR]
[TD="align: center"]07:30[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]8.00
[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]38.00[/TD]
[/TR]
[TR]
[TD="align: center"]07:30[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]8.00[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]8.00[/TD]
[/TR]
[TR]
[TD="align: center"]21:00[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]8.50[/TD]
[TD="align: center"]8:30[/TD]
[TD="align: center"]9.00[/TD]
[/TR]
[TR]
[TD="align: center"]21:00[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]8.50[/TD]
[TD="align: center"]8:30[/TD]
[TD="align: center"]8.50[/TD]
[/TR]
[TR]
[TD="align: center"]21:30[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]8.00[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]38.00[/TD]
[/TR]
[TR]
[TD="align: center"]21:30[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]8.00[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]8.00[/TD]
[/TR]
</tbody>[/TABLE]
O Column = P2*24
P Column = ((M2-L2+(M2<L2))-TIME(0,30,0))
Q Column = IF(N2="Y",(P2*24),(HOUR(P2+TIME(0,30,0))+MINUTE(P2+TIME(0,30,0))))
Thanks in advance folks.