Dividing by 60 will give you minutes, dividing by a further 60 will
give you hours, and dividing by 24 will give you days, so:

=A1/60/60/24

and format the cell as d hh:mm:ss

Hope this helps.

Pete

On May 6, 6:03*pm, Ranjith Kurian
wrote:
in a *cell i have 180000 seconds, i would like to convert this to
days:HRS:Minutes format