Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
n1kk1
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate sales run rate LoriM Excel Discussion (Misc queries) 2 May 4th 23 07:47 PM
how do I calculate a monthly payment based on a variable rate? Chick N Egg Excel Worksheet Functions 1 November 17th 05 09:00 PM
Calculate the time an employee signed in and out plus rate per hr Allan Excel Discussion (Misc queries) 2 November 7th 05 11:01 PM
Calculate Interest Rate when payment changes! huntermcg Excel Worksheet Functions 2 October 25th 05 08:32 AM
How do you calculate rate of return on monthly cash flows Philly Fan Excel Worksheet Functions 1 February 16th 05 04:24 AM


All times are GMT +1. The time now is 01:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"