Excel data

I need most common scheduled shift start and end time per department and job. If the most common schedule could show the days, that would be most helpful. So, say job 123 in dept RECEIVING, the most common schedule might be 8a-4p M-F. The most common schedule for job 234 in RECEIVING might be 9a-5p T-SAT... The attached files contain data for two different timeframes as to try to get a good sampling of data. I would need most common schedule for DEPT/JOB in each timeframe.If you are interested kindly message the project director via telegram by the username @sherriwheeler7