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...!!!
|