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