Forum Discussion
ESCHAFER1785
Aug 26, 2022Copper Contributor
time
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 ...
HansVogelaar
Aug 26, 2022MVP
Let's say you have hours worked in H2 and down. In another column in row 2, enter the formula
=ROUND(H2+1/3,0)
This can be filled down.