View Single Post
  #6   Report Post  
agenda9533
 
Posts: n/a
Default

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)