Hi, im having an absolute nightmare with this so any feedback would b
fantastic

I need to enter a formulae to calculate a column with hh:mm:s
(formatted for TIME) against a minute rate. So 00:00:30 at 20p a minut
would be 10p - help!

thn

--
n1kk
-----------------------------------------------------------------------
n1kk1's Profile: http://www.excelforum.com/member.php...fo&userid=3517
View this thread: http://www.excelforum.com/showthread.php?threadid=54939

Hi

Excel stores Time as fractions of a day so to convert to minutes,
multiply the cell value containing your time by 1440 ( 24 * 60) before
multiplying by the rate
=A1*1440*20

--
Regards

Roger Govier


"n1kk1" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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 - help!
>
> thnx
>
>
> --
> n1kk1
> ------------------------------------------------------------------------
> n1kk1's Profile:
> http://www.excelforum.com/member.php...o&userid=35173
> View this thread:
> http://www.excelforum.com/showthread...hreadid=549390
>

fantastic, thanks for that Roger - ive been staring at my pc trying t
work that out all morning!

n

--
n1kk
-----------------------------------------------------------------------
n1kk1's Profile: http://www.excelforum.com/member.php...fo&userid=3517
View this thread: http://www.excelforum.com/showthread.php?threadid=54939

Hi

You're welcome.
For future reference, please try to avoid posting the same question
under different headings, and in differing newsgroups.
It can waste a lot of time with people not realising a reply has already
been sent to the same question posted elsewhere.

--
Regards

Roger Govier


"n1kk1" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> fantastic, thanks for that Roger - ive been staring at my pc trying to
> work that out all morning!
>
> nx
>
>
> --
> n1kk1
> ------------------------------------------------------------------------
> n1kk1's Profile:
> http://www.excelforum.com/member.php...o&userid=35173
> View this thread:
> http://www.excelforum.com/showthread...hreadid=549390
>