Lunch Break Timings Calculations

**paulmichaelfarrow** · 06-05-2012, 08:12 AM

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)

**npamcpp** · 06-05-2012, 08:17 AM

You should change your thread title to something that describes your problem

Is the lunch break duration stored in a cell? Or is there data for lunch break start and lunch break finish?

**paulmichaelfarrow** · 06-05-2012, 08:29 AM

Many thanks for that, never been on sites like this before

The time taken is calculated in a cell, from input data

I hope that this helps, in order to help me

Regards
Paul