I am trying to figure out the best way to calculate how much time my department spends in classrooms teaching programs. The length per lesson (1 hour) and the number of lessons (6 lessons) in our series is always the same, but we have a different number of classrooms that we teach in per school. I have a number field with the number of classes that we’re teaching at that school and I was hoping to have a formula field where I multiply the number of classes by the 6 lessons and translate the result into a duration. However, when I do that, even with the format for the formula as a duration, I just get “0:00” as the result. Any ideas if there is a way to multiply a number by a duration and get a duration result?
Thanks so much!