ExcelBanter - Rounding in Excel

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rounding in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/58813-rounding-excel.html)

Rounding in Excel

I need to round a time to the nearest 30 minutes in Excel

JE McGimpsey

Rounding in Excel

One way:

XL stores times as fractional days, so since 30 minutes is 1/48 of a day:

=ROUND(A1*48,0)/48

format as a time.

In article ,
"DG" wrote:

I need to round a time to the nearest 30 minutes in Excel

All times are GMT +1. The time now is 01:21 PM.