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