Seems rather easy. What's your problem?
I am trying to create a time sheet where there is a start time, start lunch, end lunch and then out for the day. I need it to round the start time and out for the day by 7 minutes.
Ex. 7:53 am to 8:07 am = 8:00am
8:08 am to 8:22 am = 8:15
8:23 am to 8:37 am = 8:30
8:38 am to 8:52 am = 8:45
For the lunch break i need to have 30 minutes deducted if the break is 20 minutes or more and if the break is less than 20 minutes no time deducted. Lunch break in and out times are not rounded.