Hi,
It's probably easiest to have Start and Finish time in separate
cells: assume
Start in A2, Finish in B2 then in C2 put:

=(B2-A2)+(B2<A2)*24 ' Hours worked

This allows for say 22:00 start and 08:00 finish. Format all cells as "hh:mm"

Copy this formula down column C as appropriate.

HTH

"KeyWest JetSki" wrote:

I have a spreadsheet that I track employees hours worked I would like to
have it total the number of hours for each day in a cell.

example they worked from 8:00 AM to 3:00 PM total hours is 7

In my cell I enter 800-1500 and manually count the number of hours for each
day.

Anyway to do this in a formula?

Thanks

Tom