Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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...!!! |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
=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...!!! |
#4
|
|||
|
|||
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...!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round time to nearest quarter hr | Excel Worksheet Functions | |||
round function in excel 2000 | Excel Worksheet Functions | |||
How do I round DOWN only, 24999 to 24000. | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Round Time | Excel Worksheet Functions |