I want excel to convert 116 minutes into 1.56 min

Bonjour, *Jomby01*

116 en A1
A2 = a1*"0:01" renvoie 1:56
A2 format : hh:mm

Cela convient-il ?


--
Bien amicordialement,
P. *******


I want excel to convert 116 minutes into 1.56 min

I'm not clear on the exact requirement. But a couple possibilities:
If you've got the number 116 and want 1:56, try =A1/1440, formatted as h:mm.
If you've got 116 and want "1 hr 56 min", try =INT(A1/60) & " hr, " &
MOD(A1,60) & " min".
Hopefully one of those is close enough that you can adapt to your precise
needs.

"Jomby01" wrote:

I want excel to convert 116 minutes into 1.56 min

Bonjour, *Jomby01*

116 en A1
00:01 in a cell (ie : B5)

Select B5, edit, copy
Select A1, Edit paste special; multiplication.

Does it work ?

--
Bien amicordialement,
P. *******



I want excel to convert 116 minutes into 1.56 min

Thanks

"Jomby01" wrote:

I want excel to convert 116 minutes into 1.56 min