Quote Originally Posted by PcMax View Post
Hi,

From a list of dates in column B
I used Function that returns the data in column C
I ask what i can do to find rounding of the column D

A B C D
1 26/10/11 19.00 35 19.00.00 19.00
2 26/10/11 19.04 49 19.05.00 19.00
3 26/10/11 19.05 41 19.05.00 19.05
4 26/10/11 19.08 20 19.05.00 19.05
I believe you want this formula...

=MROUND(MOD(B3-TIME(0,2,30),1),MOD(TIME(0,5,0),1))

You will need to format the cells using this...

h:mm;@