=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
|