Hello,
I have an attachment column with mp3 files. I need to know the length of each mp3 file. Is there a way to do this by using a formula? The API does not provide anything I can use to this.
Best,
Kim
Hi,
I am trying to set a class start time based on a section. Not sure how to convert the string into a time unit. This is what I’m trying:
SWITCH(Section,
“A”, DATETIME_FORMAT(“8:00”, ‘hh:mm’),
“B”, DATETIME_FORMAT(“9:00”, ‘hh:mm’))
Almost! While what you suggested works, I need start time to be displayed in HH:mm format as well since these are weekly schedules. Ideally the durations would be displayed in HH:mm as well, but I can live with using durations as 1.25 hours rather th...