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 formulae 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 - but I don't know what fomulae would do this - help! thnx -- n1kk1 ------------------------------------------------------------------------ n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173 View this thread: http://www.excelforum.com/showthread...hreadid=549394 |
how to calculate an rate per minute
see response to your posting in public.excel
-- Regards Roger Govier "n1kk1" wrote in message ... Hi, im having an absolute nightmare with this so any feedback would be fantastic I need to enter a formulae 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 - but I don't know what fomulae would do this - help! thnx -- n1kk1 ------------------------------------------------------------------------ n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173 View this thread: http://www.excelforum.com/showthread...hreadid=549394 |
All times are GMT +1. The time now is 08:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com