Hello everyone, Does anyone have the solution to the following problem: I am looking to convert durations in the format HH:MM:SS into a number of minutes. A numerical value would be ideal so as not to neglect the seconds. A ready-made formula would be welcome, as I have no programming knowledge!! Best regards. Guigui

Conversion HH:MM:SS en mn (Excel/OpenOffice) : CCM

Réponse 1 / 5

fouy88

to convert HH:MM:SS
to hours, = Cell / ("1:0:0")
to minutes, = Cell / ("0:1:0")
to seconds, = Cell / ("0:0:1")

mimi

Sorry, it doesn't work.

cool boy

That works for me, thank you.

Réponse 2 / 5

yannick93

Hello,

The problem with this formula is that it doesn't work with durations longer than 24 hours...
I don't have an answer to the problem, but if anyone finds something, I'm interested too :)

nico

Hello... and the reverse? Do you know how to do it?
For example, if I enter 185 for the number of minutes, the formula would indicate 03:05?
Thank you for your response..

Nico

Fifi74 > nico

In cell A1 enter 185
In cell B1 for example enter the formula =A1/1440
Format cell B1 to the [h]:mm format
There you go

Réponse 3 / 5

PLVALOT

The answer is =A15*(24*3600).
In cell A15, there is a duration in hhh:mm:ss, and the result will be a number of minutes.

PLVALOT

Actually, for the minutes you need X divided by (24*60) and not (24*3600).
The formula above obviously gives seconds.

milhoute7

=A1*1440

Réponse 4 / 5

glec@x

To convert HH:MM to HH,MM, you just need to multiply by 24 and change the cell format to number. So to get seconds, you also need to multiply by 3600. It's that simple ^^

Réponse 5 / 5

onesdf Posted messages 375 Registration date Status Membre Last intervention 120

=HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1)

guigui

Thank you, a homeless person!!! This is going to change my life!!!!

guigui

Uh.... after trying, it doesn't work on my Open Office....
Maybe it is not set up correctly?
Thank you in advance
Guigui

onesdf Posted messages 375 Registration date Status Membre Last intervention 120 > guigui

Is the cell containing the time to be converted in Time format?

guigui > onesdf Posted messages 375 Registration date Status Membre Last intervention

affirmative
As a reminder, the goal is to obtain a total number of minutes, and to convert the seconds into decimals.
I spent an hour on it yesterday without succeeding.
Thank you for your patience!!!
See you soon...
Guigui

onesdf Posted messages 375 Registration date Status Membre Last intervention 120 > guigui

My bad, I misunderstood. The formula I gave you returns the number of seconds; you just need to divide the result by 60 to get what you want, so:

=(HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1))/60

Conversion HH:MM:SS en mn (Excel/OpenOffice)

5 réponses

Texture issues in enshrouded

Graphics card driver issue

Autocad: open/save window missing

Gray screen locked

Hard drive detected by bios but not by windows 10 pro

Call from: 00 00 00 00 00

How to access a local ip address outside the range?

Find a song "la la lalala lalala lalala"

Why isn't my keyboard working anymore?

Safari switched languages by itself