zaokruzivanje minuta u excelu

Pozdrav. Zanima me kako da uradim sledece:

treba da zaokruzim minute i sekunde da budu zaokruzeni minuti u smislu da ako imam od 0 do 30 sekundi da ostane broj minuta, a ako ima od 31 do 59 sekundi, onda da bude minut vise, recimo:

1:10 = 1
1:29 = 1
1:30 = 1
1:31 = 2
1:50 = 2 itd.

Da li neko zna kako na najednostavniji nacin uraditi ovo?

Čini mi se da bi ovo trebalo da radi, proveri


Edit: nisam primetio da je pitanje dopunjeno.

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

javlja neki error
EDIT: Izvini dopunio sam pitanje da bude jasnije.

Moguće da je do separatora između argumenata f-je, US verzija koristi zarez, naša, lokalizovana tačka-zarez. Pokušaj kada izmeniš.

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

Mislim da je ovo najkraće za zaokruživanje koje tražiš

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

Svaka cast druze. Mozes li molim te samo izbaciti sate da bude u formatu mm:ss (minuti i sekunde), posto ce se samo unositi minuti i sekunde?

Nema "izbacivanja", vreme se unosi u formatu h:m:s; a ako imaš specifične želje onda to rešavaš posebno.

Jedan način je da unosiš posebno minute, posebno sekunde, te ih onda spojiš u rezultujućoj, gde već računaš zaokruženo vreme. To je jedan način, sigurno da može i drugačije.
Spajanje možeš putem fje TIME(hour;minute;second), gde će kod tebe umesto hour stajati '0'.

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

Ok. Hvala mnogo druze, sve najbolje!

Jedan način - koji ti ne preporučujem, ali može da radi, jeste da prilagodiš poslednju formulu tako što ćeš izbaciti faktor *60; Pošto bi sate unosio kao da su minuti, onda bi ovo postalo suvišno, i radilo bi do određene granice. Jedino što moraš znati da to što unosiš, Excel tretira kao sate i minute i da budeš spreman na eventualne posledice. Npr, može da se desi čudno ponašanje kada ovi "minuti" premaše 23:59 što jeste zamisliv scenario.

Da bi se ovo izbegao, cela kolona u kojoj unosiš, morala bi da se formatira - npr kao tekst. Pre nego što išta uneseš. Onda možeš unositi i sate >23

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

Korekcija... :D Pade mi na pamet način kako bi ovo moglo da se reši.

Dakle, ipak bi unosio (za Excel) sate i minute ali bi se sve pre izračunavanja pomerilo za red veličina. Tj dodajemo na uneto vreme "nula sati" pa dalje tako računamo.

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

U čeliju A1,A2 itd. upisujem vrijeme dolaska npr. 10:11 i sada mi treba da se to vrijeme automatski zaokružuje u čeliji B1, B2 itd. na 10:30.
Da pojasnim, sva vremena u rasponu od 10:01 do 10:29 trebaju se zaokružiti na 10:30, a vremena od 10:31 pa do 10:59 na 11:00.
Hvala unaprijed na pomoći.

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!