View original (French)

Time Conversion LibreOffice

Solved
José-Arthure Posted messages 628 Status Member -  
 rroo -
In Libre Office, how to convert decimal numbers to hours minutes seconds.

Thank you.

Configuration: Windows XP / Firefox 10.0

--
http://site-pierre.fr/

1 answer

Answer 1 / 1
Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 782
 
To convert decimal hours into hours minutes seconds, simply divide by 24 and set the cell to the time format

For example, in A1: 3.5
In B1 enter the formula:
=A1/24
and set cell B1 to the Time format:
Format / Cells... / Numbers tab / Time
you get: 03:30:00
--
Best regards
Patrice
9
alex
 
Hello,

In my spreadsheet, this formula converts 28.75 into 4:45, whereas I want it to convert it into 29:15.
Is that possible?
Thank you in advance.
0
Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 782
 
@ Alex

You need to use the cumulative time format:
[HH]:MM
(instead of HH:MM)

Best regards
Patrice
0
alex
 
Thank you very much :)
0
rroo
 
You're welcome, cc.
0
rroo
 
lol
0