Formula needed to return a set number if time is before a certain period

[DLsteve]

Hello everyone

I have a timestamp from a thumbprint reader that I would like to tell me if staff have entered the work place by our in-house taxi service or not, the taxi only travels at 8am so if staff arrive at work before 10am then we can deduct money from their salary slip.

• If staff arrive at work before 10am then you assume they used our taxi service so we will deduct R20 (South African Rands) from their salary for that day.
• If staff arrive at work for the lunch 12pm shift then they did not use our taxi service so no deductions should take place.
• The thumbprint reader says the word "Absent" when there is no clock in data from staff member (not at work). So if the words "Absent" is present then we will not deduct for transport.
• The yellow section is where the amount must show either R20 or R0 as a number

[AliGW]

Try this:

=IFERROR(IF(VALUE(E3)>=0.416666666666667,0,20),0)