yes mike!! we really need the real out put details and input figures
to make a solution


nik it seems so simple ,
go for bob's suggesion
type in A1
put the formula in B1 : =A1
put the formula in C1 : =A1*24*60*60 (i didn't worked out the result
of 24*60*60 it is above my mind now you may be getting better figures
the intention is the get the minutes of a1 figures and show it in :ss:)

I guess you have already formated the cells with
FORMATE- CELLS- CATEGORY - CUSTOM -