Calculating cost from time

[IainG]

Hi

This is such a great forum for us novices!! Thanks to all.

I have a timesheet that calculates the no of hours someone worked
Which works fine but when I come to times it by the hourly rate i
comes up wrong.

(A) (B)
Total 27:05 (hh:mm)
Rate £9.45
Total £10.66

Any suggestions?

Thank

 

[Frank Kabel]

Hi
in B3 enter
=A1*24*B1
and format as number

 

[Mike A]

The date & time format stores its values as number of days. The
hours/minutes/seconds are the fractional part of the value.

27:05 is 1.13 days, which is the number Excel is using in your formula.

In your formula, multiply your total hours by 24 to convert this value
to decimal hours.


Mike Argy
Custom Office solutions and
Windows/UNIX applications