

 Thread Tools  Search this Thread 
#1
 
 
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 Call m:s 03:00.0 $0.72 23:00.0 $4.29 00:00.0 $1.80 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. Thanks. Z. 
#2
 
 
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  28032012 03:25 PM 
Format cells in Excel 2010  Morag T  MS Office Support  2  17032012 11:17 AM 
Excel 2010  Help with making 'Standby' apply as 7.2 in formula  Possibly: Change Event (VBA)  DMF  Windows Software  1  09022012 09:19 AM 
Replace Microsoft Excel 2010 Worksheet name via formula and link it to other  Tur^turro  Windows Software  1  13012012 05:09 PM 
excel 2010 formula  mr.dale  Windows Software  3  06032011 10:47 PM 