What happens if G3 is greater than 0 and less than 5?
Ans:If G3 less than 5 will be 0
What does other = 4:00 mean
Ans:If G3 no show any record (when employee no proper record their "in & out" will deducted 4 hours from their salary.
this are the table that help to cal. lateness of employee from lunch
if late from lunch
>0:05min ,show 0:30min (deduct half hours),but i only want to show 0:30min in Cell H
if >0.20min , show 1:30hrs
if <0:00min, show 0:00hrs(it meant they come back early or back from lunch on time)
if other ,show 4:00hrs (other meant no proper record,maybe "-",show in G3,will deducted 4 hrs
Also,i think bec of my cell E(value )lead cell G cannot calculate the "lateness"
To calculate the "lateness" should be Cell F(time value)- Cell E(General Value),
i can't set the Cell E into time value,
always show me "formula error"
formula in my Cell E =IF(B:B="Friday",1.5, IF(B:B="Sunday",0, IF(B:B="Saturday",0,1)))
What happens if G3 is greater than 0 and less than 5?
Ans:If G3 less than 5 will be 0
What does other = 4:00 mean
Ans:If G3 no show any record (when employee no proper record their "in & out" will deducted 4 hours from their salary.
this are the table that help to cal. lateness of employee from lunch
if late from lunch
>0:05min ,show 0:30min (deduct half hours),but i only want to show 0:30min in Cell H
if >0.20min , show 1:30hrs
if <0:00min, show 0:00hrs(it meant they come back early or back from lunch on time)
if other ,show 4:00hrs (other meant no proper record,maybe "-",show in G3,will deducted 4 hrs
To calculate the "lateness" should be Cell F(time value)- Cell E(General Value),
i can't set the Cell E into time value,
always show me "formula error"