Hi!

Try this:

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

Biff

"ramana" wrote in message
oups.com...
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