SOLVED
Home

Cómo introducir un número entero y hacer que se interprete como horas o minutos en vez de en días

%3CLINGO-SUB%20id%3D%22lingo-sub-860835%22%20slang%3D%22es-ES%22%3EHow%20to%20enter%20a%20whole%20number%20and%20have%20it%20interpreted%20as%20hours%20or%20minutes%20instead%20of%20days%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860835%22%20slang%3D%22es-ES%22%3E%3CP%3EWhen%20I%20enter%20for%20example%20%221%22%20in%20the%20cell%20and%20customize%20it%20with%20a%20format%20%5Bh%5D%20%22h%22%20mm%20%22min%22%20returns%20me%20%2224%20h%2000%20min%22%20and%20what%20I%20want%20is%20to%20interpret%20%221h%2000%20min%22%20and%20if%20I%20put%20%224.5%22%20(decimal%20hours)%20I%20would%20return%20%224%20h%2030%20min%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-860835%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860854%22%20slang%3D%22es-ES%22%3ERe%3A%20How%20to%20enter%20an%20integer%20and%20have%20it%20interpreted%20as%20hours%20or%20minutes%20instead%20of%20day%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860854%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20solved%20it%20myself%3A%20I%20insert%20the%20decimal%20integer%20and%20in%20another%20cell%20I%20divide%20it%20by%2024%20and%20i%20apply%20the%20format%20%5Bh%5D%20%22h%22%20mm%20%22min%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
omisacma
New Contributor

Cuando introduzco por ejemplo "1" en la celda y lo personalizo con un formato [h] "h" mm "min" me devuelve "24 h 00 min" y lo que quiero es que interprete "1h 00 min" y que si pusiera "4,5" (horas decimales) me devolviera "4 h 30 min".

 

¿Cómo puedo conseguir esto?

1 Reply
Solution

Lo he solucionado yo mismo: introductor el número entero decimal y en otra celda lo divido entre 24 y le aplico el formato [h] "h" mm "min"

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies