Employee Start Stop Off Manager Start Stop Off Hours Days Total John 2200 0700 Sat/Sun James 2300 0800 Mon/Tue 8 3 24I'm looking for a formula that computes the total hours that the employee and the manager will be working together based on their start and stop time and the number of workdays they will be together (data is only the rest days). The total is basically Hours X Days (Total hours that the manager and employee are working together in one work week). Is this possible in excel?

message edited by ChGatsby

Please include Row numbers and Column letters with your data so that we don't have to guess/assume the location of your data.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03

Ask Your Question

Weekly Poll