Formula for Telecom calculations? Time/money

G

GeekBoy

Hello.

I am trying to figure out Excel, and have not used it much.

What I need to do is put in a money amount, lets say $5 and the rate per
minute is $0.025 (2 1/2 cents) a minute.
I need the total minutes available with the total amount of money entered at
the rate listed.

My formulas are all coming out with incorrect results.

Thanks

GB
 
B

Bill Kuunders

enter 5 in A1
enter 0.025 in B1
enter =A1/B1 in C1

the result is 200 in C1
all cells are formatted as general


Bill K
Greetings from New Zealand
 
N

Niek Otten

With $5 in A1 and $0.025 in B1:
=A1/B1
You should get 200, which is the correct number of minutes.
If you need it as Excel time:
=A1/B1/24/60, format as Time, which should give you
3:20:00, which is correct

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello.
|
| I am trying to figure out Excel, and have not used it much.
|
| What I need to do is put in a money amount, lets say $5 and the rate per
| minute is $0.025 (2 1/2 cents) a minute.
| I need the total minutes available with the total amount of money entered at
| the rate listed.
|
| My formulas are all coming out with incorrect results.
|
| Thanks
|
| GB
|
 
G

GeekBoy

Bill Kuunders said:
enter 5 in A1
enter 0.025 in B1
enter =A1/B1 in C1

the result is 200 in C1
all cells are formatted as general


Bill K
Greetings from New Zealand
Click to expand...


Thanks a lot for that response and help!
 
G

GeekBoy

Niek Otten said:
With $5 in A1 and $0.025 in B1:
=A1/B1
You should get 200, which is the correct number of minutes.
If you need it as Excel time:
=A1/B1/24/60, format as Time, which should give you
3:20:00, which is correct

--
Kind regards,

Niek Otten
Microsoft MVP - Excel
Click to expand...

Thanks Nick for the help.
I need to look up what Excel time is.

GB
 
N

Niek Otten

<I need to look up what Excel time is.>

It's a fraction of a day, and a day is 1 in Excel. So 12 hours is 1/2 in Excel.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| | > With $5 in A1 and $0.025 in B1:
| > =A1/B1
| > You should get 200, which is the correct number of minutes.
| > If you need it as Excel time:
| > =A1/B1/24/60, format as Time, which should give you
| > 3:20:00, which is correct
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
|
| Thanks Nick for the help.
| I need to look up what Excel time is.
|
| GB
| >
| > | > | Hello.
| > |
| > | I am trying to figure out Excel, and have not used it much.
| > |
| > | What I need to do is put in a money amount, lets say $5 and the rate per
| > | minute is $0.025 (2 1/2 cents) a minute.
| > | I need the total minutes available with the total amount of money
| > entered at
| > | the rate listed.
| > |
| > | My formulas are all coming out with incorrect results.
| > |
| > | Thanks
| > |
| > | GB
| > |
| >
| >
|
 
A

Al Gillis

GeekBoy said:
Hello.

I am trying to figure out Excel, and have not used it much.

What I need to do is put in a money amount, lets say $5 and the rate per
minute is $0.025 (2 1/2 cents) a minute.
I need the total minutes available with the total amount of money entered
at the rate listed.

My formulas are all coming out with incorrect results.

Thanks

GB
Click to expand...

Divide the total amount offered (say $5.00) by the rate per minute ($0.025
in your example) to get the total minutes available. So $5.00 / $0.025 =
200.
 
Top