Results 1 to 5 of 5

Lunch Break Timings Calculations

Threaded View

paulmichaelfarrow Lunch Break Timings... 06-05-2012, 08:12 AM
npamcpp Re: Help with a problem 06-05-2012, 08:17 AM
paulmichaelfarrow Help with a problem 06-05-2012, 08:29 AM
jraj1106 Re: Help with a problem 06-05-2012, 08:43 AM
paulmichaelfarrow Re: Help with a problem 06-05-2012, 09:40 AM
  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    Dewsbury, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Lunch Break Timings Calculations

    I need to be able to sort out wether my employees have taken too long on their lunch break

    what I need is a formulae that works out the following

    No lunch would show a 0
    lunch between 0 and 30 mins would show a 30 mins deduction
    lunch over 31 mins would show a 45 mins deduction

    I am struggling to get a formulae to do all three conditions

    i would if anybody could help

    many thanks if you could

    Paul (Dewsbury of England)
    Last edited by arlu1201; 06-06-2012 at 03:18 AM. Reason: OP changed title in subsequent post.

Thread Information

Users Browsing this Thread

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

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