Occasional Visitor

Need help with time calculation and rounding

date and time calculation is sorted and it works out to specific nr

but need to be able to when the decimal is more than .17 round up to next number or if its less than .17 round down to the previous nr

i.e if the calculation comes to 1.17 needs to round to 2 is 1.16 needs to round to 1 or if its 3.17 need sto round to 4 but if 3.16 needs to round to 3

time in question works in 12 hour shifts with a 2 hour grace period hence the .17 (2/12 = 0.166666)

1 Reply


Let's say you have hours worked in H2 and down. In another column in row 2, enter the formula


This can be filled down.