exceltime

How to round time to nearest hour in Excel?

How to round time to nearest hour in Excel, for example:

67:45:00 will be 68:00:00
and
53:14:00 will be 53:00:00

regards

Solution

  • You can use MROUND function like this

    =MROUND(A1,"1:00")