Need assistance with Excel 2010 (Format or Formula)
I get a bill from my telephone company every month where it shows the length of the calls as follows:
Formula is 12:03:00 AM but the text in the cell displays 03:00.0
Formula is 1:00:00 AM but the text in the cell displays 00:00.0
Formula is 2:23:00 AM but the text in the cell is displayed as 23:00
The idea is that the first line is 3 minutes, the second line is 60 minutes and the third line is 143 minutes.
I need to be able to display these numbers in mm:ss. I can change the format to [mm]:ss to chenge the display as: 3:00, 60:00 and 143:00 respectively.
However, when I try to do a formula to determine the rate/min, it does not calculate properly.
Length of Amount
So my question is how do I get the rate/min from the above 2 cells. If I try a formula like "=0.72/12:03:00 AM", I get $345.60 which is incorrect. The formula should reflect the "real" minutes as "=0.72/3" which is $0.24/min.
I hope this makes sense to someone that can help.
Re: Need assistance with Excel 2010 (Format or Formula)
You will just need to enter the values as 0:mm:ss and format as [m]:ss. Since this will be now in the minutes and seconds so the simple maths will let you to calculate your stats.
Education, Career and Job Discussions
|Tags: excel, microsoft office, ms office, office 2010|
|Thread Tools||Search this Thread|
|Similar Threads for: "Need assistance with Excel 2010 (Format or Formula)"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|need assistance to compress an excel 2010 file||Vento||Windows Software||5||28-03-2012 03:25 PM|
|Format cells in Excel 2010||Morag T||MS Office Support||2||17-03-2012 11:17 AM|
|Excel 2010 - Help with making 'Standby' apply as 7.2 in formula - Possibly: Change Event (VBA)||DMF||Windows Software||1||09-02-2012 09:19 AM|
|Replace Microsoft Excel 2010 Worksheet name via formula and link it to other||Tur^turro||Windows Software||1||13-01-2012 05:09 PM|
|excel 2010 formula||mr.dale||Windows Software||3||06-03-2011 10:47 PM|