Hi, I'm having trouble figuring out how to find the total hours of a schedule for employees.

Basically, the Rows are the days of the week and the columns are names, and the times fall in the middle. The problem is the a(AM) and p(PM) are necessary because it is a 24-hour store...
[Example]
Mon Tues Total Hours
John 5a-2p 7a-1p ?
Steve 9a-4p 4p-9p ?

So what kind of formula can I use to correctly add the times, while keeping the visual a and p for the schedule to make sense to the employees?

[Example]
----------Mon ------Tues ----- Total Hours
John ----5a-2p --- 7a-1p ---------?
Steve ---9a-4p ----4p-9p ---------?

You can't put two times in one cell like that and "simply" do any time-based math on it. Start time and end time for each cell should be in a separate cell.

Upload your sheet if you want more specific assistance. Timesheets are always a bit of a bear.