Hi,

I'm working on streamlining my payroll process, and have finally managed to figure out how to convert time to whole numbers.

My next goal. Having that whole number round to the nearest quarter.

e.g. 11.08 hrs = 11 hrs
11.19 hrs = 11.25 hrs etc

The formula I have generated for this is =(SUM(C4:C10)-INT(SUM(C4:C10)))*24 while keeping the actual format of the cell in number.

The problem I am running into is, I would like this same cell to have the rounding rule, =MROUND(cell,.25)

I can make it work in a separate cell, but ideally would like it all combined.

Any suggestions would be much appreciated.