Results 1 to 9 of 9

Calculating time, potential lunch break

Threaded View

  1. #1
    Registered User
    Join Date
    06-07-2007
    Posts
    21

    Calculating time, potential lunch break

    Hi All

    I'm struggling with a formula.

    I am creating a worksheet where employees schedule work throughout the day
    eg task 1 will be start time 9am, finish time 11am. The result is 2 hours to do the task.

    The problem i'm having is that I need to do a calculation that if a task includes lunch then the result takes an hour away from the task time.
    eg task 2 will be start time 12pm, finish time 3pm, excel displays 3 hours, i need it to say 2 hours because 1-2pm is contractual lunch.

    I can't just do a day formula that says minus 1 from total as this is task orientated and will vary depending on start and finish times of each task.

    I hope someone can help.
    PS, it needs to be a formula and not vba as we have a problem with macro's if multiple people use the worksheet.
    Last edited by B1123; 10-13-2008 at 09:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Code Execution Degrades Over Time
    By KDT in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2008, 04:28 PM
  2. Calculating a percentage of a given time span
    By Jericho in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2008, 06:35 PM
  3. Time Ranges
    By jmag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2008, 03:24 PM
  4. Calculating time between process steps
    By TK5 in forum Excel General
    Replies: 3
    Last Post: 03-17-2008, 11:27 AM
  5. calculating time values
    By toivo112 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2008, 01:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1