I am trying to create a spreadsheet to calculate the hours employees work
whilte taking into consideration a .5 or 1 hour lunch.


I would like to type in a start time and an end time (ie 9:00 to 5:00).
These values can be in seperate cells. I would then like to type in a
seperate cell 1 for a 1 hour lunch. And have the total hours for the work
day equal 7.

Then I would like to be able to have a cell for total hours worked, based off
the daily hours worked cells.

My question is very similiar to a question on this link (
http://www.officekb.com/Uwe/Forum.as...ng-Frustration )
but no answer was posted.

Any help would be appreciated.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1