View Single Post
  #1   Report Post  
ramana
 
Posts: n/a
Default can we round time in excel

Hi Everybody,

In Excel we have a function round which roundup the value to the
decimal places we specify, like this can we do it for time format.
Ex: 1. 08:05:38 can we round it to 08:06
2. 08:05:28 can we round it to 08:05.
Is there any function in excel to do this if so pl. tell me.

Thanks and Regards

Ramana