I would advise that you use two columns - one for start time and
another one for finish time. Then you can get the hours in a third
column by subtracting start time from finish time and multiplying by
24.

Hope this helps.

Pete


On Aug 1, 1:56 pm, Dawn P <Dawn 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)