I am trying to create a schedule that calculates hours worked in a day. I
have several restrictions in space, so would like to have one cell that shows
start and end time, and a second cell that shows hours worked.

For instance
A1 10:00 AM - 5:00 PM
B1 8

I am basically looking for the formula to put in B1