Daily tips for using Microsoft Excel.

Thursday, February 14, 2002

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