Thread: roundown
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter F
 
Posts: n/a
Default roundown

Hi,

I have a columns of numbers that represent minutes that when I total I
convert to hours and minutes. Now I want to round down the totals to the
nearest quarter hour, that is .25, .5 or .75. I have spent quite a bit of
time fiddling with the rounddown function but can't achieve that. Anyone
able to help?!?!?

thank you Peter