Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round Up and Round Down Time
Good Morning & a Happy New Year to all subscribers in this group.
I want to round up Start times and round down Finish times to the next or previous 15 minutes in my spreadsheet. I have found MROUND but this does not work for me in all cases. There does not seem to be MROUNDUP or MROUNDDOWN available. I can get the results I want using a VLOOKUP table but is there another way? Regards to all, Dave Moore |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round Up and Round Down Time
=FLOOR(A1,TIME(,15,))
=CEILING(A1,TIME(,15,)) -- David Biddulph DaveMoore wrote: Good Morning & a Happy New Year to all subscribers in this group. I want to round up Start times and round down Finish times to the next or previous 15 minutes in my spreadsheet. I have found MROUND but this does not work for me in all cases. There does not seem to be MROUNDUP or MROUNDDOWN available. I can get the results I want using a VLOOKUP table but is there another way? Regards to all, Dave Moore |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round Up and Round Down Time
Beautiful!!
Thank You David On 1 Jan, 11:45, "David Biddulph" <groups [at] biddulph.org.uk wrote: =FLOOR(A1,TIME(,15,)) =CEILING(A1,TIME(,15,)) -- David Biddulph DaveMoore wrote: Good Morning & a Happy New Year to all subscribers in this group. I want to round up Start times and round down Finish times to the next or previous 15 minutes in my spreadsheet. I have found MROUND but this does not work for me in all cases. There does not seem to be MROUNDUP or MROUNDDOWN available. I can get the results I want using a VLOOKUP table but is there another way? Regards to all, Dave Moore- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time, & Round? | Excel Discussion (Misc queries) | |||
How do I round time | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Round UP Time | Excel Worksheet Functions | |||
How do I round time? | Excel Worksheet Functions |