View Single Post
  #7   Report Post  
Bob Phillips
 
Posts: n/a
Default

which is what I said

--
HTH

Bob Phillips

"agenda9533" wrote in message
...
Now I got it! :-))
Thank you!

"JE McGimpsey" wrote:

One way:

A1: 1,59
A2: =A1/1440

format A2 as "[m]:ss"


In article ,
"agenda9533" wrote:

Problem is - I know how to calculate this mannualy. But I need a

function
that converts a decimal number of minutes ( for example , 1.59 ) to a

time
format mm:ss (1:48)