SOLVED

Right formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2237228%22%20slang%3D%22en-US%22%3ERight%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237228%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20experts%2C%20I%20have%20a%20question%2C%26nbsp%3B%20I%20would%20like%20that%20on%20employees%20schedules%2C%20back%20of%20that%20coded%20schedules%20the%20corresponding%20time%20will%20be%20automatically%20can%20sum%20up%20at%20their%20total%20time.%20I%20am%20working%20on%20over%202000%20employees%20with%20different%20time%20table%20schedules%2C%20thats%20why%20we%20uses%20codes..i%20do%20believed%2C%20excel%20can%20be%20helpful%20to%20have%20our%20job%20done%20easier.%20Thank%20you%20in%20advance%20if%20someone%20gives%20time%20to%20answer.%20File%20uploaded%20as%20attatchment.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2237228%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello experts, I have a question,  I would like that on employees schedules, back of that coded schedules the corresponding time will be automatically can sum up at their total time. I am working on over 2000 employees with different time table schedules, thats why we uses codes..i do believed, excel can be helpful to have our job done easier. Thank you in advance if someone gives time to answer. File uploaded as attatchment. 

2 Replies
best response confirmed by glendajohansen (New Contributor)
Solution

@glendajohansen 

 

See the attached version.

Remark: codes A1 to AW were duplicated in the list at the top. I removed the duplicates, because they caused the result to be wrong.

Cells K4:K30 and B35:B88 are formatted as [h]:mm to display times over 24 hours.

Thank you so much for the help. Have a blessed day.

Sincerely,
Glenda