Thanks for your quick response as I was pulling my hair out at the work I was
being faced with €“ and yes, I rushed to do the question I got the figure wrong

Thanks again - I can now go on holiday with my work done all thanks to you €“
the site is so supportive and what you guys do to help others is tremendous


"Per Jessen" wrote:

Hi

=A1*B1*24*60

or in short:

=A1*B1*1440

The result will be: 13.38p

Hopes this helps.
....
Per


"Linda" skrev i meddelelsen
...
Can any one please advise me how I can do the following

In A1 00:27:25 (which is time hh:mm:ss)

In B1 0.488p ( which is the cost)

In C1 - I have to charge the time by the cost but what ever I have done
it
does not work the same as doing via a calculator which I do not want to do
as
I have over 8,000 in my spread sheet.

The above should come out to 13.29pence

Thank you in advance