Converting a number into time

I am currently working with a spread sheet that his hours and seconds listed as a long number as shown below.


What I am trying to do is to get that number to look like this: (39 hours : 56 Minutes)


The closest I have come is by using the formula [=(A1/60)/60] which produces 39.94. I am having the most trouble trying to get that converted into a time format HH:MM. Seconds are not needed as they are included in the minutes.

I've tried formatting but it just gives me a 0:00:00 response each time. Any kind of formulas or formats that I can use to get it to look like that?

Edit:
This is a duplicate...can be deleted. Sorry for the double post.

Use

=A1/24/60/60

and format the cell as [h]:mm

I don't think that's a standard date/time number, therefore normal formatting won't work.
And I also think you may have posted the wrong number...maybe 143784?

Anyway, if that is right you could try this.
=INT(A1/60/60)&" Hours : "&INT(MOD(A1/60/60,1)*60)&" Minutes"

Bob Phillips said:

Use

=A1/24/60/60

and format the cell as [h]:mm

Click to expand...

Worked perfectly! Thanks!