calculate phonebills

[Jason]

Hi,

I was wondering if someone can help me with a formula to check my
phonebills.

For examle:

-the rate per second is 0,0289
-the duration of the call is 00:03:07 (hh:mm:ss) minutes
-the rate according to my phonebill says it cost me 0,14 cents excl. tax.

The problem is, when i calculate it, i'm getting a different result. What i
did was divide the 3 minutes with 60 seconds + 7 seconds. Which gave me 187
seconds, multiplied by the rate 0,0289, the result was 5,4043?

This could not be right, so i hope someone sees the formula to this.

Thnx

 

[MGFoster]

Hi,

I was wondering if someone can help me with a formula to check my
phonebills.

For examle:

-the rate per second is 0,0289
-the duration of the call is 00:03:07 (hh:mm:ss) minutes
-the rate according to my phonebill says it cost me 0,14 cents excl. tax.

The problem is, when i calculate it, i'm getting a different result. What i
did was divide the 3 minutes with 60 seconds + 7 seconds. Which gave me 187
seconds, multiplied by the rate 0,0289, the result was 5,4043?

This could not be right, so i hope someone sees the formula to this.

Nothing do to w/ Access, but:

((3 * 60) + 7) * 0.0289 = 5.4043

 

[Jason]

Hi,

I want to create the formula in an access query. But the result of the
formula should be 0,14 instead of 5,4043.

Do you know the calculation to get 0,14, so i can use it in a query.