C
Colin
I am using the formula MROUND to get a time hh:mm:ss to the nearest 30seconds.
Cell T2 shows 00:11:24 and U2 shows 30.
I have fomated cell T2 and the cell I want the answer in as hh:mm:ss.
However the answer cell shows 11:30:00. this seems to be taking the MM and
showing as HH and ss as MM.
=TIME(MINUTE(T3),MROUND(SECOND(T3),U3),0) is the formula and the cell is
formatted hh:mm:ss
Can anyone help me to rectify this?
Cell T2 shows 00:11:24 and U2 shows 30.
I have fomated cell T2 and the cell I want the answer in as hh:mm:ss.
However the answer cell shows 11:30:00. this seems to be taking the MM and
showing as HH and ss as MM.
=TIME(MINUTE(T3),MROUND(SECOND(T3),U3),0) is the formula and the cell is
formatted hh:mm:ss
Can anyone help me to rectify this?