AnsweredAssumed Answered

How do I multiply time with a decimal value?

Question asked by jonasmn on Feb 2, 2019
Latest reply on Feb 2, 2019 by mark_b

I have a field of the type TIME (hh:mm) and I want to multiply this value with a value from a decimal field. To be precise, I have a project where I have calculated the amount of hours and minutes that needs to fullfill the task. In another field I have the cost for one hour, and now I want to multiply the hourly cost with the amount of time needed, and get that value in decimal form. How do I convert the hh:mm to a decimal value so that I can peform this calculation?

 

 

Jonas Möller Nielsen

Sweden

Outcomes