can we round time in excel

[ramana]

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

 

[Ron Rosenfeld]

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

 

[Biff]

Hi!

Try this:

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

Biff

 

[MikeY]

=MROUND(A1,"0:1")

 

[ramana]

Hi

Thankyou all of you, they are working well.

Thanks and Regards

Ramana