Ludak
Slavan
- Učlanjen(a)
- 14.09.2005
- Poruke
- 1,261
- Poena
- 375
Ćao,
Imam dvije kolone u Excelu.
Kolona A je ime i prezime zaposlenog. (primjer Marko Marković)
Kolona B je dan, datum i vrijeme (primjer: 09.11.2021 12:12:00)
Zanima me kako je moguće formulom ili VBA kodom "izvući" najmanje i najveće vrijeme za određeni dan?
Primjer
U koloni C i D (ili nekon novom Sheetu/Fajlu) bi trebalo da piše kao rezultat:
Kao što vidite svaki zaposleni za jedan dan, može da ima dva rezultata, najmanji i najveći za kolonu B.
Imam dvije kolone u Excelu.
Kolona A je ime i prezime zaposlenog. (primjer Marko Marković)
Kolona B je dan, datum i vrijeme (primjer: 09.11.2021 12:12:00)
Zanima me kako je moguće formulom ili VBA kodom "izvući" najmanje i najveće vrijeme za određeni dan?
Primjer
| Marko Marković | 01.11.2021 9:02 |
| Marko Marković | 01.11.2021 13:40 |
| Marko Marković | 01.11.2021 14:07 |
| Marko Marković | 01.11.2021 17:00 |
| Marko Marković | 02.11.2021 9:03 |
| Marko Marković | 02.11.2021 11:49 |
| Marko Marković | 02.11.2021 12:46 |
| Marko Marković | 02.11.2021 17:00 |
| Marko Marković | 03.11.2021 9:01 |
| Marko Marković | 03.11.2021 17:03 |
| Marko Marković | 04.11.2021 8:59 |
| Marko Marković | 04.11.2021 11:10 |
| Janko Janković | 01.11.2021 8:47 |
| Janko Janković | 01.11.2021 17:29 |
| Janko Janković | 02.11.2021 8:35 |
| Janko Janković | 02.11.2021 12:06 |
| Janko Janković | 02.11.2021 15:52 |
| Janko Janković | 02.11.2021 16:08 |
| Janko Janković | 02.11.2021 16:16 |
| Janko Janković | 02.11.2021 16:26 |
| Janko Janković | 02.11.2021 17:31 |
| Janko Janković | 03.11.2021 8:34 |
| Janko Janković | 03.11.2021 10:46 |
| Janko Janković | 03.11.2021 12:10 |
| Janko Janković | 03.11.2021 12:28 |
| Janko Janković | 03.11.2021 13:13 |
| Janko Janković | 03.11.2021 14:48 |
| Janko Janković | 03.11.2021 16:26 |
| Janko Janković | 03.11.2021 17:23 |
| Janko Janković | 04.11.2021 8:36 |
| Janko Janković | 04.11.2021 10:35 |
| Janko Janković | 04.11.2021 10:48 |
| Janko Janković | 04.11.2021 14:20 |
| Janko Janković | 04.11.2021 14:27 |
| Janko Janković | 04.11.2021 16:20 |
| Mirko Mirković | 01.11.2021 8:51 |
| Mirko Mirković | 01.11.2021 10:18 |
| Mirko Mirković | 01.11.2021 10:20 |
| Mirko Mirković | 01.11.2021 10:22 |
| Mirko Mirković | 01.11.2021 10:30 |
| Mirko Mirković | 01.11.2021 10:30 |
| Mirko Mirković | 01.11.2021 18:14 |
| Mirko Mirković | 02.11.2021 8:59 |
| Mirko Mirković | 02.11.2021 9:03 |
| Mirko Mirković | 02.11.2021 9:07 |
| Mirko Mirković | 02.11.2021 9:39 |
| Mirko Mirković | 02.11.2021 9:39 |
| Mirko Mirković | 02.11.2021 11:49 |
| Mirko Mirković | 02.11.2021 12:46 |
| Mirko Mirković | 02.11.2021 15:21 |
| Mirko Mirković | 02.11.2021 15:37 |
| Mirko Mirković | 02.11.2021 17:32 |
| Mirko Mirković | 03.11.2021 9:08 |
| Mirko Mirković | 03.11.2021 10:33 |
| Mirko Mirković | 03.11.2021 10:41 |
| Mirko Mirković | 03.11.2021 14:47 |
| Mirko Mirković | 03.11.2021 14:55 |
| Mirko Mirković | 03.11.2021 15:26 |
| Mirko Mirković | 03.11.2021 16:23 |
| Mirko Mirković | 03.11.2021 17:31 |
| Mirko Mirković | 04.11.2021 8:53 |
| Mirko Mirković | 04.11.2021 9:33 |
| Mirko Mirković | 04.11.2021 9:42 |
| Mirko Mirković | 04.11.2021 12:59 |
| Mirko Mirković | 04.11.2021 13:07 |
| Mirko Mirković | 04.11.2021 13:41 |
| Mirko Mirković | 04.11.2021 15:19 |
U koloni C i D (ili nekon novom Sheetu/Fajlu) bi trebalo da piše kao rezultat:
| Marko Marković | 01.11.2021 9:02 |
| Marko Marković | 01.11.2021 17:00 |
| Marko Marković | 02.11.2021 9:03 |
| Marko Marković | 02.11.2021 17:00 |
| Marko Marković | 03.11.2021 9:01 |
| Marko Marković | 03.11.2021 17:03 |
| Marko Marković | 04.11.2021 8:59 |
| Marko Marković | 04.11.2021 11:10 |
| Janko Janković | 01.11.2021 8:47 |
| Janko Janković | 01.11.2021 17:29 |
| Janko Janković | 02.11.2021 8:35 |
| Janko Janković | 02.11.2021 17:31 |
| Janko Janković | 03.11.2021 8:34 |
| Janko Janković | 03.11.2021 17:23 |
| Janko Janković | 04.11.2021 8:36 |
| Janko Janković | 04.11.2021 16:20 |
| Mirko Mirković | 01.11.2021 8:51 |
| Mirko Mirković | 01.11.2021 18:14 |
| Mirko Mirković | 02.11.2021 8:59 |
| Mirko Mirković | 02.11.2021 17:32 |
| Mirko Mirković | 03.11.2021 9:08 |
| Mirko Mirković | 03.11.2021 17:31 |
| Mirko Mirković | 04.11.2021 8:53 |
| Mirko Mirković | 04.11.2021 16:38 |
Kao što vidite svaki zaposleni za jedan dan, može da ima dva rezultata, najmanji i najveći za kolonu B.
