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

[David Biddulph]

=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.]

 

[JE McGimpsey]

One way:

XL stores times as fractional days...

A1: 1.5
A2: =A1/1440

Format A2 as a time.


Sewall6606 <[email protected]> wrote:

 

[Peo Sjoblom]

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