 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007Formula for Telecom calculations? Time/money
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 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 > Hello. > [quoted text clipped - 10 lines] > > GB > enter 5 in A1 > enter 0.025 in B1 [quoted text clipped - 5 lines] > Bill K > Greetings from New Zealand Thanks a lot for that response and help! >> Hello. >> [quoted text clipped - 10 lines] >> >> GB 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  SignatureKind regards, Niek Otten Microsoft MVP - Excel | Hello. | [quoted text clipped - 10 lines] | | GB > 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 Thanks Nick for the help. I need to look up what Excel time is. GB > | Hello. > | [quoted text clipped - 11 lines] > | > | GB <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. SignatureKind regards, Niek Otten Microsoft MVP - Excel | > With $5 in A1 and $0.025 in B1: | > =A1/B1 [quoted text clipped - 23 lines] | > | | > | GB > Hello. > [quoted text clipped - 10 lines] > > GB 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.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.