0
format in time
Good morning,
I have built a db where with as main table: Titles
Fields include: Genre and duration.
Now I want to create a dashboard. Select Titles. I get the genres in the chart but it does not add up the duration. I guess I will have to enter a format but format('duration', "hh-mm-ss") does not work.
Is it possible at all? And if so, what should the formula be?
Thanks.
Rob
4 replies
-
What kind of field is duration?
said:
Now I want to create a dashboard. Select Titles. I get the genres in the chart but it does not add up the duration.What chart are you talking about?
-
Hi Fred
It's a time field
-
Sorry, it's a time interval field
-
said:
Sorry, it's a time interval fieldIf I'm not mistaken there is no field that is called time interval. I'm not sure how the timeinterval() command would work here.
Can you upload a sample DB?
Content aside
- 1 yr agoLast active
- 4Replies
- 78Views
-
2
Following