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
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
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" <[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 - 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 to work that out all morning!
nx
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks