You're welcome. I forgot to say to format the cell to currency or whatever
format you want but I guess you have found that out already <g

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"MoniqueT" wrote in message
...
Thanks Sandy.

"Sandy Mann" wrote:

If your times really are in XL times like 10:00:30 then try:

=(B1-A1)*24*60*60*F1
where the rate is in F1

or by doing the multiplication:

=(B1-A1)*86400*F1


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"MoniqueT" wrote in message
...
I would like to work out a formula to multiply the result of an equation
(10.00.30 - 10.00.00 in hh:mm:ss) by an amount of money. I am
calculating
archive costs so I need to know what the amount of archive is by
subtracting
the end time code from the beginning, and then multiplying by the cost
per
second.

Thanks,

Monique