ExcelBanter - View Single Post

MoniqueT

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