On 17-Apr-07 21:20 (+1000 UTC), *Andis Lazdinsh* posted:
Thank you for the idea!
A1*24 gives wrong result, but A1*24*60 is correct.
Andis
Assuming that 00:16:42 is hours, minutes, seconds (HH:MM:SS) you want
to convert it to decimal hours
if A1 contains the time, then use
A1*24
which will give you 0.2811 in decimal hours
then multiply by the hourly rate (50 euros)
50*a1*24
to get the cost.
You'll need the *60 if your time is in MM:SS rather than HH:MM:SS - glad
you got it sorted.
Klaas Visser
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
