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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shift Objects 2
shifting values 2
Shift information 2
range shift 1
Shifting Objects 2
Evaluating Work Shifts 5
Excel Shift Roster 9
cell heights shift 1

Top