Rounding in Excel

[DG]

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

[JE McGimpsey]

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 <[email protected]>,
"DG" <[email protected]> wrote:

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