shift

E

!..:: Enang ::..!

This is my problem, let say that I got 3 shifts


Colomn A fill with Employer ID_No
Colomn B fill with Date
Colomn C fill with Shift
Colomn D fill with In_Time
Colomn E fill with Out_Time
Colomn F fill with Absen or Present
Colomn G fill with Overtime

Shit I 08:00 AM to 04:00 PM ; normal work hour, next hour will be
overtime
Shit II 04:00 PM to 12:00/00.00 AM ; normal work hour, next hour will be
overtime
Shit III 00:00 AM to 08:00 AM ; normal work hour, next hour will be
overtime

I need the formula to calculate hour in COlomn F & G

thank for any help
 
Top