# Anyone has a workaround for displaying Time Durations on Charts? **URL:** \ **Category:** Ask for Help\ **Created:** [March 15, 2020, 8:05pm UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453 "2020-03-15T20:05:35Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![boomage](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomage/32/4329_2.png) [@boomage](https://community.glideapps.com/u/boomage)\ **Post date:** [March 15, 2020, 8:05pm UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/1 "2020-03-15T20:05:36Z")
I contacted Glide about this and they related that Glide does not support time durations on charts yet. Instead of a time duration of 03:15:00 (hh:mm:ss) displaying on the chart, the chart displays the underlying number instead, like 12120, which my users will not understand. Anyone has a workaround for this issue? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 15, 2020, 9:57pm UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/2 "2020-03-15T21:57:57Z")
What formula do you use to generate the time value? ---
**Author:** ![boomage](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomage/32/4329_2.png) [@boomage](https://community.glideapps.com/u/boomage)\ **Post date:** [March 15, 2020, 10:01pm UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/3 "2020-03-15T22:01:20Z")
Hi Robert, thanks for the hit back. I am not too sure how to answer that. I collect the duration time from a Google Form (users enter the length of time they practiced their dances for a Leaderboard) which gets collected on a Google Sheet. Hope that helps… ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 15, 2020, 10:46pm UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/4 "2020-03-15T22:46:00Z")
In a new column type this formula: `{“Duration”;ARRAYFORMULA(IF(ISBLANK(A2:A),””,TEXT(A2:A,”hh:mm:ss”)))}` where column A is your time column. Use this column for the chart to see if it makes a difference. ---
**Author:** ![boomage](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomage/32/4329_2.png) [@boomage](https://community.glideapps.com/u/boomage)\ **Post date:** [March 16, 2020, 4:35am UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/5 "2020-03-16T04:35:52Z")
Ty Robert, I’m gonna try that out now and lyk. ---
**Author:** ![boomage](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomage/32/4329_2.png) [@boomage](https://community.glideapps.com/u/boomage)\ **Post date:** [March 16, 2020, 5:55am UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/6 "2020-03-16T05:55:33Z")
Robert, I’m not a techie, but I tried the following: 1. I copied the formula you provided, changed the A’s to F’s (the column with the duration on my sheet), inserted a new column to my sheet, and inserted the formula there. Nothing happened. 1. So, I tried removing the { } and the “Duration;”, and just put the arrayformula in the column It returned with FORMULA PARSE ERROR. 1. Finally, I tried just: =TEXT(F2,“hh:mm:ss”) It returned with FORMULA PARSE ERROR. Any ideas? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 16, 2020, 10:04am UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/7 "2020-03-16T10:04:07Z")
Did you copy/paste my solution? If so, perhaps retype it from scratch? My quotation marks weren’t playing nice on my phone. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [March 16, 2020, 12:48pm UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/8 "2020-03-16T12:48:12Z")
When you post code here you can’t post it via normal typing within the body of the text. You need to surround it with 3 backticks ` Here it is the code, can you see the difference in the quotes. ```auto {"Duration";ARRAYFORMULA(IF(ISBLANK(A2:A),"",TEXT(A2:A,"hh:mm:ss")))} ``` ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/33190742fb534758a7c060332c555a7cbc9d440e.png) ---
**Author:** ![boomage](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomage/32/4329_2.png) [@boomage](https://community.glideapps.com/u/boomage)\ **Post date:** [March 16, 2020, 3:06pm UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/9 "2020-03-16T15:06:07Z")
Robert, retyping the formula worked. Tyvm. 1. When I select that text version of the DURATION field for the LABEL for the Bar Chart, the data displays just fine as hh:mm:ss. 2.However, when I select that text version of the DURATION field for the QUANTITY for the Bar Chart, the data still displays as the underlying number (ex - 12120) and NOT hh:mm:ss. 1. Also, the Y-Axis displays the underlying number, too. ---
**Author:** ![boomage](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomage/32/4329_2.png) [@boomage](https://community.glideapps.com/u/boomage)\ **Post date:** [March 16, 2020, 3:07pm UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/10 "2020-03-16T15:07:26Z")
ty yes i do see that the quotation marks are different! ---
**Author:** ![boomage](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomage/32/4329_2.png) [@boomage](https://community.glideapps.com/u/boomage)\ **Post date:** [March 16, 2020, 3:39pm UTC](https://community.glideapps.com/t/anyone-has-a-workaround-for-displaying-time-durations-on-charts/5453/11 "2020-03-16T15:39:22Z")
Robert, I decided to convert the duration to numeric hours and now the chart reports the data accurately and in a way my users will understand. I appreciate your help. Aloha…