How to convert a number into a time format

[Umesh Chahar]

Hi ,
I have a number 72 hours when i am trying to convert it into time format in hh:mm:ss using text funtionand by foramtting it but it is giving 00:00:00 by text function and 1728:00:00 by formatting it .please suggest how to change 72 into time format 72:00:00 like this . so please help

 

[Faseeh]

Divide Original Number (72) by 24 and then Apply HH:MM:SS format

 

[Mike H..]

Hi,

Hi ,
I have a number 72 hours when i am trying to convert it into time format in hh:mm:ss using text funtionand by foramtting it but it is giving 00:00:00 by text function and 1728:00:00 by formatting it .please suggest how to change 72 into time format 72:00:00 like this . so please help

Hi,

In addition to the above (Dividing by 24) you must apply a custom format of

[H]:mm:ss

if you apply a standard format of hh:mm:ss then the 72 hours will display as zero because that format allows time to roll over to zero after 24 hours.

 

[Ajesh]

assuming number in A1
in A2 =TEXT(A1/24,"[h]:mm:ss")