Formula to count times a specific number will divide into another + rounding rules

  • Hi all,


    Working with medical billing and attempting to determine how many 15-minute units are within a specific period of time. For example, if I have 120 minutes in a cell, the output should read 8. This part, I can easily calculate, but I do not want the answer to be in decimal format and I want any remainder greater than 8 to be counted as an additional unit.


    e.g., 116 minutes/15 = 7r11 so I would like this cell to read 8.


    Thanks, all! Fond memories of Ozgrid help back when I was writing macros for my dissertation :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!