MROUND time

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?
 
P

p45cal

Colin;522199 said:
I am using the formula MROUND to get a time hh:mm:ss to the neares
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 M
and
showing as HH and ss as MM.

=TIME(MINUTE(T3),MROUND(SECOND(T3),U3),0) is the formula and the cel
is
formatted hh:mm:ss

Can anyone help me to rectify this?

I haven't looked too closely at the question, but would this be wha
you're after?:
=TIME(HOUR(T3),MINUTE(T3),MROUND(SECOND(T3),U3)
 
D

Dave Peterson

I used this formula:
=MROUND(T2,TIME(0,0,30))
and saw:
00:11:30
And if I had that 30 in U2, then this worked:
=MROUND(T2,TIME(0,0,U2))
 
D

Dave Peterson

ps.

This formula worked ok, too:
=MROUND(T2,1/24/60/2)
but I find it less obvious than:
=MROUND(T2,time(0,0,30))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top