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)

if the numbers involved are minutes then:
=IF(F108="","",MROUND(MIN(40,C108+E108-F108),15))
It they're hours then:
=IF(F108="","",MROUND(MIN(40,C108+E108-F108),0.25))


unless, that is, you want to do the rounding of the individual numbers first.

Thanks works great!!!