Calculate total hours per week per schedule

**rizmomin** · 12-14-2013, 10:40 PM

Hello:

Please refer to attached sheet.

I am using the attached to schedule the employees.
All I want is a formula to add up all schedule hours per week per schedule in cell R2,R3 and R4.

Please let me know if any questions.

Thank you.

Riz Momin

**Ron Coderre** · 12-14-2013, 11:12 PM

Using your posted workbook...Here are two approaches

This regular formula calculates the sum of each days hours worked

Please Login or Register  to view this content.

This ARRAY FORMULA, completed by holding down CTRL and SHIFT when you press ENTER (instead of just pressing ENTER) returns the same sum

Please Login or Register  to view this content.

Format the formula cells as: Time 37:30:55

In your example, the formula returns: 34:30:00 hours

Copy either formula down as far as you need.

Is that something you can work with?

**rizmomin** · 12-14-2013, 11:28 PM

Hi Ron:

That's great, it works like a charm.

Thank you so much.

Riz Momin

Calculate total hours per week per schedule

LinkBack

Thread Tools

Rate This Thread

Display

Calculate total hours per week per schedule

Re: Calculate total hours per week per schedule

Re: Calculate total hours per week per schedule

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] 40 Hours per week / how to calculate overtime hours

Allocate total hours from schedule to total hourly breakdown chart multiple personnel

Calculating total shift hours in a schedule

Total schedule hours

[SOLVED] how do I calculate hours from a schedule

Bookmarks

Bookmarks

Posting Permissions