On 17-Apr-07 20:04 (+1000 UTC), *Andis Lazdinsh* posted:
Hello!
I have rather simple problem. I calculate machinery cost per hour, for
instance, 50 EUR, and I calculate time spent for certain operation, for
instance 00:16:42 (numeric value 0,01160..). Now I have to calculate
actual cost of operation. I found that I can't understand, how calc
calculates numeric value and I can't implement this simple task.
I tried to found principle, how calc calculates numeric values of time
functions in help section and user forums, but there is huge load of
irrelevant information. May be someone can send simple solution.
Sincerely,
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]
