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,