It's kind of slow at work so I thought I might knock this out just for fun, it's not my job but a chance to learn something new. The main thing that I would like to learn how to do is this:
To save confusion for the employees and keep it readable for them but with functionality, I want to learn how to create a conditional time format that understands that "7a-3p" is "7:00AM-3:00PM" and a total of 8 hours for the Hourly total at the last column. Would this be a formula or formatting? I really don't know where I should be looking for this but that's why this forum exists right?

PS: Google Sheets is preferred but not necessary, trying to make this usable with Google Calendar so that we can all subscribe to the calendar and it updates ours with our work schedule whenever it changes.