How to convert numbers in HH:MM format

[ThrottleWorks]

Hi,

I have value as 100 in cell A1, in cell B1 I am trying to get result as 1:40, which is 1 hour and 40 minutes.

If value is 90, result should be 01:30, in case of 30, result should be 30 only.
Can anyone please help me in this.

 

[vletm]

ThrottleWorks
=A1/1440

 

[ThrottleWorks]

Hi @vletm sir, thanks for the help. However I am not getting desired output.
For example, formula is giving result as 0.06 for 90. Idealy it should be 1:30

 

[vletm]

C/Would You format that cell to use 'time'-format?

... and with 'Custom', You can even show only hours and minutes.

 

[Chihiro]

If there's chance of value greater than 1 from calculation result use following format. "[h]:mm" otherwise "hh:mm" or "h:mm".