On 7 Nov 2005 20:14:21 -0800, "ramana" wrote:

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

To Round to the nearest minute, with your time in A1:

=ROUND(A1/TIME(0,1,0),0)*TIME(0,1,0)


--ron