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.
I'm not sure where you get the 0.01160 from.
Hope this helps,
Klaas Visser
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
