rounding to nearest five minutes

  • Thread starter Thread starter TS Mathews
  • Start date Start date
T

TS Mathews

I'm a total newby with trying to use Excel (or any spreadsheet for that
matter) and I need a simpy rounding process but can only find things for
rounding to 15 minute intervals or else always rounding up or down. Is
there a formula to simply round :02 down to :00 and :03 up to :05?

I apologize if this is right under my nose and I'm just too stupid to find
it. ;-)

Tim
 
One way:

XL stores times as fractional days, and there are 288 5-minute periods
in a day, so:

=ROUND(A1*288,0)/288

Format as time if necessary
 
Much thanks...I knew it had to be WAY easier that all the IF THEN's I was
trying to string together!! ;-)
 
Back
Top