View original (French)

90 minutes

Solved
christophedir Posted messages 201 Status Membre -  
christophedir Posted messages 201 Status Membre -
Hello
I took a good look, but I can't find what I'm looking for

In A1 I have a production time in hh:mm (01h30)

In A2 I would like the sum of hours and minutes, which is 90

Best regards

christophedir

3 réponses

Réponse 1 / 3
Anonymous user
 
Hello,
Try A2=(HOUR(A1)*60)+MINUTE(A1), it works in LibreOffice.
--
I don't know any more than you do, but I'm looking.
1
Réponse 2 / 3
christophedir Posted messages 201 Status Membre
 
Hello old-painful

The formula works

Thank you

Best regards

CHristophedir
0
Réponse 3 / 3
ccm81 Posted messages 11033 Status Membre 2 434
 
Hello to both of you

You have a bit simpler
=A1*1440

Best regards
0
christophedir Posted messages 201 Status Membre
 
Hello

I just saw your message, and your solution works great

Thank you
0