Multiplying time by cost

[Guest]

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,

 

[T. Valko]

You have to convert the time to seconds:

=Time * 86400 * multiplier

A1 = 0:00:10
B1 = 10

=A1*86400*B1

Format as GENERAL or NUMBER

Result = 100

 

[Pete_UK]

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