Hi all
request your help to calculate the following in excel.

Office timing is 09:30
if report late by 5 min = in time
if report late by 06 to 30 min = half hour late
if report late by 30 to 1 hr = 1 hr late
if late mark count more than 4 times deduct half day salary