If A1 =09:00 & B1=16:00 then hours worked in C1:

=B1-A1

I recommend you put Start & End times in different columns


"Dawn P" wrote:

I am trying to create schedule for employees by tracking their hours in one
column (9am-4pm) and to find a formula that will calculate the total number
of hours in the next column. (9am-4pm) (7 hours)