Thread: Round Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl carl is offline
external usenet poster
 
Posts: 42
Default Round Question

My time data looks like this (formated as number)

93245
124316
135946

I would like a formula that will round the time to the nearest "5"
minutes. Results like this:

930
1245
1400

Thank you in advance.