View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DaveMoore DaveMoore is offline
external usenet poster
 
Posts: 32
Default 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