Parmesh,

Please understand that the post I provided is what you requested. However,

please also understand that it makes no logical sense. The .85 is really

85/100 of a minute which is 60 * (85 / 100) = 51 seconds. The "correct"

answer is therefore:

select convert(int, 2445566331/60), 'minutes',

convert(int, round ((2445566331/60 - floor (2445566331/60)) * 60,

0)), 'seconds'

> Parmesh,

> It took me a while, but I believe I understand what your problem is.

Permit

> me to rephrase it just to make sure that we both agree. Numerically,

> 2445566331 / 60 is indeed 40759438.85. However, you are looking for a

result

> in seconds and fractions of seconds. So you want to take the .85, which is

> 85/100, and convert that to

> 1.25 seconds, and then add that to 40759438 to yield 40759439.25.

> select convert(int, 2445566331/60) +

> convert(int, ((2445566331/60 - floor (2445566331/60)) * 100) /

> 60) +

> (convert(int, ((2445566331/60 - floor (2445566331/60)) * 100)) %

> 60) / 100.0

> > Hi Every body

> > I have problem, I don't want to say it is a problem I don't know how

> to

> > do it.

> > here is a situation

> > 1) (Sumof talktime / #of Calls) it gives me 'Average Talk Time', but it

> > gives me in numeric, I want in decimal ( because we calculate on half

hour

> > basis for one day,if I neglect decimal places it makes lot of difference

> for

> > me)

> > 2) Lets say this 'Average talk time' for the day is 2445566331 seconds,

> Now

> > I have to give this in HH:MM:SS it is not limited to 24hrs, it can be

like

> > this 120:45:22 (HH:MM:SS)

> > ( 2445566331/60)=40759438.85 (mm:ss, when I am dividing

by

> 60

> > still it is giving 85 seconds, it doesn't make any sense, it supposed to

> be

> > 40759439.25)

> > How can I achieve this

> > please let me know

> > Parmesh