Rounding Time to a Specific Value

February 14, 2002 - by Juan Pablo Gonzalez

Rob asks:

I have programed a cell to round the time to the nearest quarter hour. Such as, 8 hours 14 minutes would show as 8:15:00. Now I want to program the cell to show that 8:15:00 as 8.25. What is the formula for that?

If you have 8:15:00 in A1, use this formula (And format as General, or as Number with 2 decimals)

=A1*24