Hello and Good Morning everyone,
im a new user and still new in excel.
please help me, i seek your guidance,
A1= time in, 8:30
B1= time out, 20:00
office hour start at 08:30am with 1/2hour Grace period,
but need to cover back late hour within same day after 5.30pm.
for example;-
if late 1min need coverback 1min,
if 15min need coverback 15min
End hour at 05:30pm, means 8working and 1hour breaktime (12pm to 1pm, no need punch),
and overtime until time out.
my excel now, 100% same like my references.
Can you help me how to create the correct formula?
your cooperation is highly appreciated.
Thank you.
Bookmarks