View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

=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