Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015

    Unanswered: Spreadsheet for calculating late breaks

    Hi guys,

    I'm trying to create a spreadsheet that will automatically calculate the late breaks (when a member of staff has took too long for their break) when the raw data is entered.

    Name /Number /Staffed Time /AUX Time /Default /Break /Lunch
    John Smith /12345 /09:15:43 /1:11:27 /:25:01 /:14:09 /:29:44

    I'd like it to be able to calulate their break entitlement based on the staffed time, so for example, on an 8 hour shift they would get 20 minutes worth of breaks and a 30 minute lunch, and if then if they are over by more than 1 minute, it would conditionally format the cell red.

    What's the best way to set this up as I'm struggling to get it to work at the moment.

    Many thanks.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 10
    Have a read of this to get you started:
    Home | Blog

Posting Permissions

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