ExcelBanter - Rounding time to nearest Hour

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding time to nearest Hour (https://www.excelbanter.com/excel-worksheet-functions/36797-rounding-time-nearest-hour.html)

SierraRose

Rounding time to nearest Hour

In Excel, is there a way to round off time to the nearest hour. 6:10 would
become 6:00; 6:30 would be 7:00.

Peo Sjoblom

One way

=ROUND(A1/(1/24),0)*(1/24)

where A1 holds your time, format as time or you'll probably get a decimal
number

--
Regards,

Peo Sjoblom

(No private emails please)

"SierraRose" wrote in message
...
In Excel, is there a way to round off time to the nearest hour. 6:10
would
become 6:00; 6:30 would be 7:00.

All times are GMT +1. The time now is 01:14 AM.