Compute Total Hours in a Work Week

September 4, 2018 at 16:12:16
Specs: Windows 10
Employee   Start   Stop      Off      Manager    Start  Stop      Off	   Hours  Days Total
 John	   2200    0700    Sat/Sun    James      2300   0800    Mon/Tue    8	  3     24

I'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


See More: Compute Total Hours in a Work Week

Reply ↓  Report •

#1
September 4, 2018 at 20:11:17
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


Reply ↓  Report •
Related Solutions


Ask Question