Hi!
If I understand you correctly you are teaching six 1hr lessons at multiple schools (each with a different number of classrooms? If that’s the case, I created a mockup:

The formula field just multiplies across the row:

It looks like you may have a blank field in your formula that is being treated as a 0.
Let me know if I’m understanding you incorrectly. If you could send a screenshot of a mockup that’d be helpful.
/edited to fix images]
That’s essentially it!
I was hoping to find a way to not have to enter that there are 6 lessons at a 1 hour duration every time I make a new record, since it’s the same for every school, so was trying to see if it was possible just to have the # of classes as a field in my table and have the duration built into the formula.
What I tried to do, but seem to not be possible, is multiply the # of classrooms by 6 and asked AIrtable to format the result as a duration - but since there isn’t a duration in the formula it just resulted in 0:00.


That’s essentially it!
I was hoping to find a way to not have to enter that there are 6 lessons at a 1 hour duration every time I make a new record, since it’s the same for every school, so was trying to see if it was possible just to have the # of classes as a field in my table and have the duration built into the formula.
What I tried to do, but seem to not be possible, is multiply the # of classrooms by 6 and asked AIrtable to format the result as a duration - but since there isn’t a duration in the formula it just resulted in 0:00.


Actually, your problem is just that Airtable interprets “durations” as “seconds” on the backend. Your formula is multiplying 6*number of classrooms - let’s say it’s 5 - resulting in the value 30
as output.
When you tell it to display the value as a “duration”, it takes the value 30
and displays it as 30
seconds in the field. You have the formatting set to cut off the seconds, and only show accuracy to the minute, so the result is 0
minutes (0:00
).
What you need to do is multiply the output by the the number of seconds it should represent - 3600. Then, your “Duration” output will show what you are wanting.
Actually, your problem is just that Airtable interprets “durations” as “seconds” on the backend. Your formula is multiplying 6*number of classrooms - let’s say it’s 5 - resulting in the value 30
as output.
When you tell it to display the value as a “duration”, it takes the value 30
and displays it as 30
seconds in the field. You have the formatting set to cut off the seconds, and only show accuracy to the minute, so the result is 0
minutes (0:00
).
What you need to do is multiply the output by the the number of seconds it should represent - 3600. Then, your “Duration” output will show what you are wanting.
Aha, that makes so much sense! Everything is exactly right now. Thank you so much!