View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shiv
 
Posts: n/a
Default Round Time to 30 minutes

Hello All,

I want to write a function that will round my stat time and end time fields
to 30 minutes.

i.e. if start time is 10:20 it should be converted to 10:30 and if it is
10:40, it should be converted to 11:00 so on and so forth.

Your help on this will be much appreciated