Time Calculation For A Timesheet To Include Lunch

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have seen many postings for time calculation but nothing that
includes a factor for lunch.
I am trying to create a Timesheet so I can calculate the number of
hours worked per day, but have not been able to find a way to include
the Lunch time in the formula and to have it displayed correctly.

I have cells for Start Time and End Time formatted as HH:MM, plus Lunch
formatted as Numeric. Example: Start 8:30AM, End 5:30PM, Lunch 1:00

A formula of End - Start (ie: D4-C4) will give me 9:00 (9 hours).
How can I deduct the 1 hour for lunch?
This is not a time, just a number of hours/minutes.
I tried converting to all different values with no luck.
Thanks in advance.
Tony

.

Relevant Pages

  • Re: Thanouxay
    ... Begin now claims to have full knowledge of Thanouxay's hours of work, lunch ... about Thanouxay and all other national/international spokespeople. ... Besides the obvious fact that the top spokesperson of a nation can ... Yong does most of his postings will reveal a thing or two. ...
    (soc.culture.laos)
  • Thankyou all
    ... For your good luck and best wishes postings, ... I am to be in for 4 o'clock so time for some lunch before i do my makeup LOL ...
    (uk.people.silversurfers)
  • RE: Timesheets
    ... To complicate matters, besides stretching across midnight, that timesheet was ... split into a before-break (lunch) and after-break periods. ... engineers indicate the time slot in which they take there lunch this ... means we accurately deduct the time from the correct contract. ...
    (microsoft.public.excel.misc)
  • RE: Timesheets
    ... To complicate matters, besides stretching across midnight, that timesheet was ... split into a before-break (lunch) and after-break periods. ... engineers indicate the time slot in which they take there lunch this ... means we accurately deduct the time from the correct contract. ...
    (microsoft.public.excel.misc)
  • Re: Add hours together
    ... >I'm trying to do up a timesheet - very basic mon-fri. ... >lunch and time out. ... Format the cell in which you have the SUM function: ... Prev by Date: ...
    (microsoft.public.excel.misc)