Avtomatsko upisivanje smene

Avtomatsko upisivanje smene 01.06.2013. u 18:24 · pre 163 meseca #1

Imam tabelu u kojoj se unosi vreme povratka radnika.To vreme se upisuje u koloni A.Radi dalje analize potrebno mi je ako se radnik bude vratio od 07:00 do 15:00 u koloni B da se paralelno upise "I" (kao prva smena), ako se vrati od 15:01 do 22:00 upise "II" i od22:01 do 06:59 upise "III". Trazio sam po prethodnim temama i sam sam nesto probao ali mi ne ide. Moli o bi da mi neko pomogne.
Unapre vam hvala

avtomatsko upisivanje smene.xlsx8.51k

Re: Avtomatsko upisivanje smene 01.06.2013. u 19:24 · pre 163 meseca #2

Formula za B2

Code:

=REPT("I";LOOKUP(A2;0+{0;"7:";"15:1";"22:1"};{3;1;2;3}))

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!

Re: Avtomatsko upisivanje smene 01.06.2013. u 20:16 · pre 163 meseca #3

Evo malo lakše razumljivija formula (ali zato duža):

Code:
=IF(AND(A2>TIME(7;;);A2<TIME(15;;));"I";IF(AND(A2>TIME(15;;);A2<TIME(22;;));"II";"III"))

Konačno sam pronašao kako se na srpskoj tastaturi kuca horizontalni vektor: {={1\2\3\4}}

Ova 3okc-ova formula može i ovako da se napiše:

Code:
=LOOKUP(A2;0+{0\"7:01"\"15:01"\"22:01"};{3\1\2\3})

Mod: Tagovi

Re: Avtomatsko upisivanje smene 01.06.2013. u 21:00 · pre 163 meseca #4

Hvala na pomoci.

Re: Avtomatsko upisivanje smene 02.06.2013. u 21:13 · pre 163 meseca #5

Ako je ona preth. bila previše razumljiva, evo još dve :)

Code:
=ROMAN(TEXT(SUM(1-(A2<0+{1;"22:1";"15:1";"7:"}));"0;;3"))

Code:
=ROMAN(TEXT(MATCH(A2;0+{0;"7:";"15:1";"22:1"})-1;"0;;3"))

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!

1

Forum kao aplikacija na telefonu

Srodne teme