View original (French)

Convert decimal number to h/mn in Excel

Solved
isa -  
 hanaa -
Hello,
can you tell me how to convert 1.25 (which is 1 hour and 15 minutes) into the result: 1 h 15 mn
thank you
Configuration: Windows XP Internet Explorer 6.0

3 réponses

Réponse 1 / 3
LePierre Posted messages 249 Status Membre 338
 
Hello

you just need to divide your value by 24 (=24 h) and set the format of your cell (C3 in the example) to time (hh:mm)
example:
if in B3 you have: 1.25
paste in C3: 
=B3/24
--> 01:15

see you later
84
Blabla
 
Half an hour I've been looking for the answer in Excel's help. Thank you LePierre for this information.
9
Anonyme > Blabla
 
Hello,
I need to convert 4.9 hours into hours and minutes and I don't know how to do it. Please help me.
1