how to calculate an rate per minute

[n1kk1]

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

[Roger Govier]

see response to your posting in public.excel

--
Regards

Roger Govier


"n1kk1" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>