View original (French)

Round seconds up to the next minute

Solved
nathan027 Posted messages 3 Registration date   Status Member Last intervention   -  
nathan027 Posted messages 3 Registration date   Status Member Last intervention   -
Hello

I would like to round my time up to the next minute, for example the following times

00:00:33 > Would become 00:01:00
00:45:06 > Would become 00:46:00
01:24:22 > Would become 01:25:00

Thank you in advance :)

1 answer

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello

    With the time in B2, in C2:
    =TIME(HOUR(B2),MINUTE(B2)+IF(SECOND(B2)>0,1,0),0)

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    1
    1. nathan027 Posted messages 3 Registration date   Status Member Last intervention   1
       
      PERFECT, thank you Via55 :)
      0