Yes, times are stored as fractions of a 24-hour day, so to convert to
seconds you would need to multiply as follows:

=A1*B1*24*60*60

where A1 contains your time and B1 your rate.

Hope this helps.

Pete

On Sep 25, 9:58 pm, kippers wrote:
Hi,

I am trying to calculate some activity costs and have some timings that I
want to multiply against some salary costs. The timings on the spreadsheet
are in the format [h]:mm:ss and the costs are per second (as I want to be as
accurate as possible). However, when I multiply [h]:mm:ss by the cost per
second I get a weird answer. e.g.

0:00:30 * 0.50 = 0.25?

I suppose ideally I could do with coverting the [h]:mm:ss into seconds only
(i.e. 0:01:30 would equal 5400)?? so that both data are in seconds??

Any ideas gratefully received!

Cheers,