[엑셀] 초를 시분초로.. 2000 => 00:00:00
E2가 셀~ =IF(QUOTIENT(E2,3600)=0,"00:",IF(LEN(QUOTIENT(E2,3600))=1,"0""IENT(E2,3600),QUOTIENT(E2,3600))&":")&IF(MOD(QUOTIENT(E2,60),60)=0,"00:",IF(LEN(MOD(QUOTIENT(E2,60),60))=1,"0"&MOD(QUOTIENT(E2,60),60),MOD(QUOTIENT(E2,60),60))&":")&IF(MOD(E2,60)=0,"00",IF(LEN(MOD(E2,60))=1,"0"&MOD(E2,60),MOD(E2,60)))
일상/이야기
2025. 1. 16. 16:42