How do I change minutes (1.5) to 01:30?
 

How do I change minutes (1.5) to 01:30?
 

=A1/(24*60)

[... and next time, please ask the question in the body of the text, not in
the subject line. Blank messages are often ignored.]
--
David Biddulph

"Sewall6606" wrote in message
...

How do I change minutes (1.5) to 01:30?
 

One way:

XL stores times as fractional days...

A1: 1.5
A2: =A1/1440

Format A2 as a time.


In article ,
Sewall6606 wrote:

How do I change minutes (1.5) to 01:30?
 

Divide by 1440 and format as hh:mm:ss or mm:ss


--
Regards,

Peo Sjoblom




"Sewall6606" wrote in message
...