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