I need to round a time to the nearest 30 minutes in Excel
J JE McGimpsey Dec 5, 2005 #2 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.
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.
