View Single Post
  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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)