Thread: round time to nearest 15mins e.g. 16:12 to 16:15

Hi

I am building a project tracker time thing in excel and need the value in a cell (which reads over from another cell) to round to the NEAREST 0.25 for

The multiples need to be 0.25, 0.5, 0.75 and a whole number


for example 15:43 needs to round to 15:45 as we only monitor in complete 15 minutes.

Thank you in advance

If you're using XL2007 you can use MROUND (without need for activating Analysis ToolPak)

B1: =MROUND(A1,"00:15")

where A1 holds time of interest

pre XL2007 if you prefer to avoid ATP then perhaps:

B1: =(ROUND((A1*24)/0.25,0)*0.25)/24