VERY,VERY URGENT

VERY,VERY URGENT

Post by Parmes » Sun, 06 Feb 2000 04:00:00



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

 
 
 

VERY,VERY URGENT

Post by BPMargoli » Sun, 06 Feb 2000 04:00:00


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


Quote:> 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


 
 
 

VERY,VERY URGENT

Post by Joseph Clar » Sun, 06 Feb 2000 04:00:00


To turn a number of seconds into HHH:MM:SS, just use modulus functions.
Get the number of seconds with is MOD(time,60). The number of minutes is
MOD((time/60),60). The number of hours is time/3600. No problem.
-joe clark
-----Original Message-----

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

 
 
 

VERY,VERY URGENT

Post by BPMargoli » Sun, 06 Feb 2000 04:00:00


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