Multiplying seconds by cost

[MoniqueT]

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

 

[Gary''s Student]

If the time difference is in A1 and the cost per second is in B1, then:

=A1*24*60*60*B1

will convert into integer seconds and then apply the cost.

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[MoniqueT]

Thank you VERY very much. That's fantastic.

 

[MoniqueT]

Thanks Sandy.

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk