160;
예를 들면, 아래와 같1008; 내용1060; 3천,148; 1060;상1060; .104;lj16;데 1068;1068;1060; 확1064;Ȣ16;기가 7192;들Ǻ12;서
Ȟ17;1068; 업무 외시간(20:00 ~ 08:00) or 공휴1068;에 1217;근한 ID를 찾아서 확1064;.108; ID에 빨간색1004;/196; O 표시를 Ȣ16;고dz10;습니다...
수식1012; Ǻ12;떻,172; 사용해야 Ȣ16;나요..?
(1221;상)
ID 160; 160; 160; 160; 1217;속시간
ABC 160; 160;2020-10-12 13:30
ABC 160; 160;2020-10-13 13:30
ABC 160; 160;2020-10-14 13:30
160; 160; 160; 160; 160; 160; 160; :
160; 160; 160; 160; 160; 160; 160; :
160; 160; 160; 160; 160; 160; 160; :
(비1221;상)
ID 160; 160; 160; 160; 1217;속시간
abc 160; 160;2020-10-11(공휴1068;) 21:00
abc 160; 160;2020-10-10(공휴1068;) 21:00
abc 160; 160;2020-10-08 21:00
160; 160; 160; 160; 160; 160; 160; :
160; 160; 160; 160; 160; 160; 160; :
160; 160; 160; 160; 160; 160; 160; :
d
=IF(WEEKDAY(B1)=1, "O", IF(WEEKDAY(B1)=7, "O", IF(HOUR(B1) >= 20, "O", IF(HOUR(B1) < 8, "O", ""))))
°ú Á¶°ÇºÎ ¼½Ä»ç¿ë
ÀÏ¿äÀÏ, Åä¿äÀÏ, 20½Ã~7:59:59 ±îÁö O Ç¥±â
°ø°ø±â°ü¿¡¼´Â ÈÞÀÏ µ¥ÀÌŸ¸¦ º°µµ ½ÃÆ®¿¡ ´Ù ä¿ö³Ö°í ´Ù¸¥ ½ÃÆ®¿¡¼ ÂüÁ¶Çؼ »ç¿ëÇÏ´õ¶ó±¸¿ä
³»ÀÏ µå¸±¼ö´Â ÀÖ½À´Ï´Ù
open api
ÇÏÁö¸¸ ³ëµ¿ÀýÀº ºüÁ®ÀÖ´Ù´Â ÈĹ®....
5/1 Ãß°¡ÇÏ½Ã¸é µË´Ï´Ù.
https://www.data.go.kr/data/15012690/openapi.do
http://www.2cpu.co.kr/PDS/13699 > csv ·Î ¿Ã·Á³ù½À´Ï´Ù.