Thread: Rounding time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amy Amy is offline
external usenet poster
 
Posts: 165
Default Rounding time

Hi,

I would like to round time to the nearest minute in Excel. For example have
a time that is 7:03:01 and 7:03:59 and they both appear as 7:03 with the
format h:mm when I would prefer they appear as 7:03 and 7:04. Can anyone
please tell me how I can do this.

Regards,

Amy