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

can we round time in excel
 

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

can we round time in excel
 

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

can we round time in excel
 

=MROUND(A1,"0:1")

--
Mike

"ramana" wrote in message oups.com...

can we round time in excel
 

Hi

Thankyou all of you, they are working well.

Thanks and Regards

Ramana