Thread: [Solved] MROUND funtion
View Single Post
 
Old 10-26-2018, 03:27 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 872
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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.
Reply With Quote