cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
%3CLINGO-SUB%20id%3D%22lingo-sub-677801%22%20slang%3D%22fr-FR%22%3Eformato%20de%20fecha%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677801%22%20slang%3D%22fr-FR%22%3E%3CP%3EBuenos%20dias%2C%3C%2FP%3E%3CP%3E%3CFONT%3ETengo%20una%20base%20de%20datos%20con%20dos%20columnas%3A%20entrada%20y%20salida.%20%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%3EEstas%20columnas%20son%20fechas%20pero%20tienen%20el%20formato%20incorrecto.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_1-1694701647772.png%22%20style%3D%22width%3A%20272px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56651i6B60D19273B9FA81%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hcarr01_1-1694701647772.png%22%20alt%3D%22hcarr01_1-1694701647772.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CFONT%3EPor%20ejemplo%20la%20celda%2014.45%20corresponde%20a%20las%2014.45%20horas.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIntent%C3%A9%20modificar%20el%20formato%20de%20la%20columna%20diciendo%20que%20en%20la%20entrada%20era%20formato%20num%C3%A9rico%20y%20en%20la%20salida%20me%20gustar%C3%ADa%20%22h%3Am%22%20como%20se%20muestra%20a%20continuaci%C3%B3n%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hcarr01_0-1694701578439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56650i561CDFD641C368D8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hcarr01_0-1694701578439.png%22%20alt%3D%22hcarr01_0-1694701578439.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEsto%20no%20funciona%2C%20%C2%BFtiene%20alguna%20idea%20para%20resolver%20este%20problema%2C%20por%20favor%3F%3C%2FP%3E%3CP%3EGracias%20por%20sus%20respuestas%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-677801%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EAcceso%20a%20los%20datos%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECombinaci%C3%B3n%20y%20limpieza%20de%20datos%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-677816%22%20slang%3D%22en-US%22%3ERe%3A%20formatear%20fecha%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677816%22%20slang%3D%22en-US%22%3E%3CP%3EEl%20problema%20es%20que%20el%20tiempo%20en%20JMP%20se%20clasifica%20como%20segundos.%2014.45%20no%20est%C3%A1%20en%20segundos%2C%20por%20lo%20que%20debes%20convertir%20tus%20n%C3%BAmeros%20a%20segundos.%3C%2FP%3E%0A%3CP%3EProbablemente%20exista%20una%20forma%20m%C3%A1s%20econ%C3%B3mica%20de%20hacer%20esta%20f%C3%B3rmula%2C%20pero%20%C3%A9sta%20muestra%20exactamente%20lo%20que%20est%C3%A1%20sucediendo.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56653i75A14BEE0FB26A41%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Dan_Obermiller_0-1694704306809.png%22%20alt%3D%22Dan_Obermiller_0-1694704306809.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELa%20primera%20parte%20(antes%20del%20signo%20%2B)%20toma%20la%20porci%C3%B3n%20entera%20y%20la%20convierte%20a%20segundos.%20La%20segunda%20parte%20encontrar%C3%A1%20la%20fracci%C3%B3n%20de%20la%20entrada%2C%20multiplicar%C3%A1%20por%20100%20para%20convertirla%20a%20un%20n%C3%BAmero%20entero%2C%20dividir%C3%A1%20por%2060%20para%20convertirla%20a%20una%20fracci%C3%B3n%20de%20hora.%20Luego%2C%20la%20funci%C3%B3n%20%22En%20horas%22%20lo%20convertir%C3%A1%20a%20segundos.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-677863%22%20slang%3D%22en-US%22%3ERe%3A%20formatear%20fecha%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677863%22%20slang%3D%22en-US%22%3E%3CP%3EPara%20a%C3%B1adir%20a%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3194%22%20target%3D%22_blank%22%3E%20%40Dan_Obermiller%3C%2FA%3E%20respuesta%2C%20el%20siguiente%20script%20realizar%C3%A1%20los%20cambios%20en%20el%20lugar%20para%20la%20columna%20principal%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Current%20Data%20Table()%3B%0A%0AFor%20Each%20Row(%0A%20%3Aentr%C3%A9e%20%3D%20In%20Hours(%20Floor(%20%3Aentr%C3%A9e%20)%20)%0A%20%2BIn%20Hours(%0A%20%20Modulo(%20%3Aentr%C3%A9e%2C%20Floor(%20%3Aentr%C3%A9e%20)%20)%20*%20(100%0A%20%20%20%2F%2060)%0A%20)%0A)%3B%0A%3Aentr%C3%A9e%20%26lt%3B%26lt%3B%20Format(%20%22h%3Am%22%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1694713320569.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56656iAC7ED4B7502AFD96%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22txnelson_0-1694713320569.png%22%20alt%3D%22txnelson_0-1694713320569.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678010%22%20slang%3D%22fr-FR%22%3ERe%3A%20formato%20de%20fecha%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678010%22%20slang%3D%22fr-FR%22%3E%3CP%3Egracias%20por%20sus%20respuestas%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
hcarr01
Level VI

format date

Bonjour,

Je dispose d’une BD avec deux colonnes : entrée et sortie.
Ces colonnes sont des dates mais sont au mauvais format.

hcarr01_1-1694701647772.png


Par exemple la cellule 14,45 correspond à 14h45.

 

J’ai essayé en modifiant le format de la colonne en disant qu’en entrée il s’agissait de format numérique et en sortie je voudrais « h:m » comme ci dessous :

 

hcarr01_0-1694701578439.png

 

cela ne fonctionne pas, avez-vous une idée pour résoudre ce problème SVP ?

Merci pour vos réponses !

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: format date

The issue is that time in JMP is categorized as seconds. 14.45 is not in seconds, so you need to convert your numbers into seconds.

There is likely a more economical way to do this formula, but this one shows exactly what is going on.

Dan_Obermiller_0-1694704306809.png

 

The first part (before the + sign) takes the integer portion and converts to seconds. The second part will find the fraction of the entry, multiply by 100 to convert to an integer, divide by 60 to convert to a fraction of an hour. Then, the "In Hours" function will convert that to seconds.

Dan Obermiller

View solution in original post

txnelson
Super User

Re: format date

To add to @Dan_Obermiller response, the below script will make the changes-in-place for the entrée column;

Names Default To Here( 1 );
dt = Current Data Table();

For Each Row(
	:entrée = In Hours( Floor( :entrée ) )
	+In Hours(
		Modulo( :entrée, Floor( :entrée ) ) * (100
		 / 60)
	)
);
:entrée << Format( "h:m" );

txnelson_0-1694713320569.png

 

Jim

View solution in original post

3 REPLIES 3

Re: format date

The issue is that time in JMP is categorized as seconds. 14.45 is not in seconds, so you need to convert your numbers into seconds.

There is likely a more economical way to do this formula, but this one shows exactly what is going on.

Dan_Obermiller_0-1694704306809.png

 

The first part (before the + sign) takes the integer portion and converts to seconds. The second part will find the fraction of the entry, multiply by 100 to convert to an integer, divide by 60 to convert to a fraction of an hour. Then, the "In Hours" function will convert that to seconds.

Dan Obermiller
txnelson
Super User

Re: format date

To add to @Dan_Obermiller response, the below script will make the changes-in-place for the entrée column;

Names Default To Here( 1 );
dt = Current Data Table();

For Each Row(
	:entrée = In Hours( Floor( :entrée ) )
	+In Hours(
		Modulo( :entrée, Floor( :entrée ) ) * (100
		 / 60)
	)
);
:entrée << Format( "h:m" );

txnelson_0-1694713320569.png

 

Jim
hcarr01
Level VI

Re: format date

merci pour vos réponses !