Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to calculate an rate per minute
Hi, im having an absolute nightmare with this so any feedback would be fantastic I need to enter a formula to calculate a column with hh:mm:ss (formatted for TIME) against a minute rate. So 00:00:30 at 20p a minute would be 10p - help! thnx -- n1kk1 ------------------------------------------------------------------------ n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173 View this thread: http://www.excelforum.com/showthread...hreadid=549395 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to calculate an rate per minute
try this where A1 = 20 20 equalling your 20p dont put p or formula wont work then you can change it also so if it become 30p that will change the outcome and A2 = time A1/60 divids into seonds * A2 seond multiplied by the time = your answer =(A1/60)*A2 -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=549395 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to calculate an rate per minute | Excel Discussion (Misc queries) | |||
how do I calculate a monthly payment based on a variable rate? | Excel Worksheet Functions | |||
Calculate the time an employee signed in and out plus rate per hr | Excel Discussion (Misc queries) | |||
Calculate Interest Rate when payment changes! | Excel Worksheet Functions | |||
How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions |