Excel vba code for working out hours in a roster

As the title says, I wish to be able to work out how many hours, automatically, people have been rostered on for...

Capture.PNG

In this example I have a group of employees that work certain hours, but not the same hours each week and I need to be able to work out if anyone is either too low (contractual) or too many...

For example :
Monday
Alfred (D5) works for 12 (F4) hours
Edina (D8) works for 6 (F7) hours
Leonie (D11) 6 (F10) hours

Tuesday
Leonie (G5) a 12 (I4) hours
Spencer (G8) a 6 (I7)


The hours of each shift is the greyed numbers in F, I etc and Id like to be able show the total hours for each person...

The hours of each shift is the greyed numbers in F, I etc and Id like to be able show the total hours for each person...

Formula in F4

=TIME(LEFT(RIGHT(D4,4),2),RIGHT(D4,2),0)-TIME(LEFT(RIGHT(D4,9),2),LEFT(RIGHT(D4,7),2),0)

If you upload a workbook with before/after, it will help to write a vba code.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you Jindon, but that wasn't what I needed, I need to be able to show the TOTAL hours per week for each individual person

Can not write a code from a PICTURE.

As requested, Sheet2 is original (redacted)
Sheet2 (2) is what I'd like to be able to get... but doing it automatically

Inparticular column X to go with the names in W

You need to check your calculation...

Please Login or Register  to view this content.

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.