Round down for time
 

Can someone provide a formula to use for rounding down time data.
Example 9:37 needs to round down to 9:30 and 7:25 needs to round down to 7:00.

Thanks - in advance...!!!

=FLOOR(A1,TIME(0,30,0))
And format as time.

Shadowman13 wrote:

Can someone provide a formula to use for rounding down time data.
Example 9:37 needs to round down to 9:30 and 7:25 needs to round down to 7:00.

Thanks - in advance...!!!

--

Dave Peterson

=ROUNDDOWN(A10*48,0)/48

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shadowman13" wrote in message
...
Can someone provide a formula to use for rounding down time data.
Example 9:37 needs to round down to 9:30 and 7:25 needs to round down to
7:00.

Thanks - in advance...!!!

Your examples are rather ambiguous, but I'll assume you want to round
down to the nearest half-hour:

=FLOOR(A1,"00:30")

or, since XL stores times as fractional days, equivalently

=FLOOR(A1,1/48)


In article ,
"Shadowman13" wrote:

Can someone provide a formula to use for rounding down time data.
Example 9:37 needs to round down to 9:30 and 7:25 needs to round down to 7:00.

Thanks - in advance...!!!