2007/4/17, Klaas Visser <[EMAIL PROTECTED]>:
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
0.01160 is correct. It is 0.01160 "days" (assuming that 1 day=24 h) which is 16 minutes, 42 seconds, or 16.7 minutes, which is the same thing, or indeed 16×60+42 = 1002 seconds. 24 h = 24×60² = 86400 seconds. So these 00:16:42 is 1002/86400 = 0.011597222... "days", which is just about 0.0160 "days". *Way out of topic and just for my own curiosity*: By the way, is there an English word for 24 hours? In Swedish we have "dygn", which is not the same thing as "dagar". 1 dygn = 24 h, 1 dag = 1 day, 2 dagar = 2 days, 1 natt = 1 night and so on. In movies made in UK, Australia, USA etc, they always say things like 48 hours, 72 hours etc, never things like 43 hours or 77 hours, which make me believe that there really is no English word for a period of 24 hours. It's easier for us, we just say 2 dygn, 3 dygn and so on. We don't have to multiply with 24... =) Can "days" sometimes mean "24 h" in English? I was not sure, that's why I put "days" within quotes in my first paragraph above... Johnny Andersson
