How to round time to nearest hour in Excel?

excel time roundup
alwbtc picture alwbtc · Nov 19, 2013 · Viewed 59.6k times · Source

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

Answer

barry houdini picture barry houdini · Nov 19, 2013

You can use MROUND function like this

=MROUND(A1,"1:00")

Related questions

Display milliseconds in Excel

I am trying to display milliseconds in an Excel macro. I have a column of integers which are timestamps in milliseconds (e.g. 28095200 is 7:48:15.200 am), and I want to make a new column next to it which keeps a running …

Read More
How to get the difference in minutes between two dates in Microsoft Excel?

I am doing some work in Excel and am running into a bit of a problem. The instruments I am working with save the date and the time of the measurements and I can read this data into Excel with …

Read More
Converting MM:SS.ms to seconds using MS excel

I am looking for a neat way of converting a cell from Minutes:Seconds.Milliseconds to Seconds.Milliseconds i.e. 11.111 = 11.111 1:11.111 = 71.111 I have something in place at the moment but its a bit hacky and I am sure there must be …

Read More