ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to calculate an rate per minute (https://www.excelbanter.com/excel-discussion-misc-queries/92576-how-calculate-rate-per-minute.html)

n1kk1

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


Roger Govier

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