Need Formula to convert Minutes into hh:mm:ss

[Powrpak]

Ok .. here is the problem . . .
I have a spot on my spreadsheet where I am given an ammount of time in minutes.
I need to convert it to hours:minutes:seconds (ie: hh:mm:ss)
Can anyone help??

Example:
6214.11 must be converted to 103:43:12
In other words:
6214.11 minutes becomes 103hours, 43mins, 12 seconds

Can be done either one of 2 ways ...
Dont care which as long as it works.

Either:
A3=PRODUCT(A1,A2)
B1=(formula here converting answer from A3 to hh:mm:ss)
OR
use the current
A3=PRODUCT(A1,A2)
and somehow change the number format to show it the way i need it to.
(none of the preset number formats works unless you have a custom one i can use)

[NBVC]

Possibly there is a better way... but this seems to work... although I don't get the exact number you do...

=TEXT(INT(B1/60),"00:")&TEXT(INT(MOD(B1/60,1)*60),"00:")&TEXT(ROUND(MOD(MOD(B1/60,1)*60,1)*60,0),"00")


Where B1 has your time in minutes.

Or if you want your PRODUCT() formula incorporated:

=TEXT(INT(PRODUCT(A1,A2)/60),"00:")&TEXT(INT(MOD(PRODUCT(A1,A2)/60,1)*60),"00:")&TEXT(ROUND(MOD(MOD(PRODUCT(A1,A2)/60,1)*60,1)*60,0),"00")

[daddylonglegs]

Try this formula in A3

=A1*A2/1440

custom format A3 as [h]:mm:ss

[NBVC]

That's embarrassing....

I don't know why I didn't come up with that.. got confused maybe with the [h] functionality...

At least mine and your end numbers match, dll, although mine is text and yours is number.. and both don't match what the OP says should be the result...

[Powrpak]

I thank you guys greatly ... I love this forum!!