ȷ㷨
117.2814000 ת1171653.04
=INT(D2)&""&INT((D2-INT(D2))*60)&""&ROUND((((D2-INT(D2))*60)-INT((D2-INT(D2))*60))*60,2)&""

=TEXT(A1/24,"[h]mmss")

117.2814000 ת1172814
=INT(A1)&""&IF(INT((A1-INT(A1))*100)<10,"0"&INT((A1-INT(A1))*100),INT((A1-INT(A1))*100))&""&IF(INT((A1*100-INT(A1*100))*100)<10,"0"&INT((A1*100-INT(A1*100))*100),ROUND((A1*100-INT(A1*100))*100,2))&""



=INT(D16)&""&INT((D16-INT(D16))*100)&""&ROUND(((D16*100-INT(D16*100))*100),D82)&""