Hi All, I want to calculate the time an item takes to create from a table of times I already have. For example: 1 banner takes 15 mins However, if I have 5 languages, this would mean the time to produce that banner is 15x5 = 75 mins or 1.25 hours - is there anyway I can achieve this calculation on a custom form using calculated fields? I'm pretty sure I can, but I'm not sure exactly where the logic should sit? 1) The data sits in the calculated field, on creation of the field and references only the number of languages from the custom form 2) It references the data from the custom form - ie languages = 5 and banner = 15 and the calculated field is purely referencing these fields to make the calculation? I am doing my advanced reporting now, but im not far enough in to come up with the solution for this and this is fairly urgent... thanks in advance! Miranda Rais GVC
