I have a spread sheet that tracks benifit time for employees.
I need it to round to the nearest 15. Been trying to incorperate the MROUND function but not having any luck. The formula in the cell is =IF(F108="","",MIN(40,C108+E108-F108)). This adds any time earned and subtracts time used and tops out at 40, but our time clock works on 15 minute interavals. Hopefully I have attached the file.
Any insite would be gratly appreciated.
Thanks,

Attached Files

Benifit Time-2018.xlsx (63.6 KB, 10 views)