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

guigui -
Louis14 - 3 Apr 2019 at 09:13

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

Configuration: Windows Vista Internet Explorer 7.0

5 answers

Answer 1 / 5

Best answer
The best answer is the one that has been validated by our teams.
fouy88

to convert HH:MM:SS
to hours, = Cell / ("1:0:0")
to minutes, = Cell / ("0:1:0")
to seconds, = Cell / ("0:0:1")
99
1. mimi
  
  Sorry, it doesn't work.
  
  0
2. cool boy
  
  That works for me, thank you.
  
  0
Answer 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 :)
8
1. 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
  
  0
  1. 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
    
    0
Answer 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.
4
1. PLVALOT
  
  Actually, for the minutes you need X divided by (24*60) and not (24*3600).
  The formula above obviously gives seconds.
  
  0
2. milhoute7
  
  =A1*1440
  
  0
Answer 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 ^^
3
Answer 5 / 5
onesdf Posted messages 375 Registration date Status Member Last intervention 120

=HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1)
1
1. guigui
  
  Thank you, a homeless person!!! This is going to change my life!!!!
  
  0
2. guigui
  
  Uh.... after trying, it doesn't work on my Open Office....
  Maybe it is not set up correctly?
  Thank you in advance
  Guigui
  
  0
3. onesdf Posted messages 375 Registration date Status Member Last intervention 120 > guigui
  
  Is the cell containing the time to be converted in Time format?
  
  0
4. guigui > onesdf Posted messages 375 Registration date Status Member 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
  
  0
5. onesdf Posted messages 375 Registration date Status Member 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
  
  0

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

5 answers

Computer that locks itself automatically

History of messages for new members in whatsapp discussions

Server error: "uid copy: uid copy failed"

Sound disappears after returning from sleep mode

Connecting a sony handycam video 8 ccd f555e to an hd tv

Download openoffice without extensions

Get office for free

Unable to install the media feature pack on windows ...

Pocophone f1 phone and moto g 77 phone

Java 25 i can’t edit my comments anymore.