I have a spreadsheet that calculates my in & out time at work .. I have that
set up with a date, time in, time out .. my formula correctly adds my number
of hours .. I take a standard hour for lunch .. so I've made another column
... and I want it to subtract one hour from that total to give me net hours
worked .. I can't seem to get my formulas to work for the final two columns
... here is my questions ..

On the column that has the 1 hour for lunch .. what would I format that as?

For example here is my spreadsheet .. I can't figure out the formula for
lunch break colun & net hours worked column ..

I appreciate any & all help for the Excel gurus & experts on here :) ..
A B C D E
F
Date TIME IN TIME OUT TOTAL HRS WK. LUNCH BREAK NET HRS WORKED
09/08/08 8:00 AM 5:45 PM 9:45 1.00