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