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 