I run a small business that I need to schedule the work hours for my
employees on a sheet. A particular cell contains the hours work for an
mployee from 2 am-5 Pm, 2 pm- 9pm. That were exactly what I put down.
However, I want excel to automatically add the total hours worked by each
employee in the right most colum. However, I cannot use the sum function
with the format from above. Is there a different way for me to input the
hours, so that the sum function will work, but I still want a format
similar to the once from above?

Thank You.