# View the duration of the stopwatch in USC **URL:** \ **Category:** Ask for Help\ **Created:** [September 16, 2021, 9:08pm UTC](https://community.glideapps.com/t/view-the-duration-of-the-stopwatch-in-usc/31874 "2021-09-16T21:08:16Z")\ **Posts on this page:** 1\ **Showing post:** 7
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 16, 2021, 10:13pm UTC](https://community.glideapps.com/t/view-the-duration-of-the-stopwatch-in-usc/31874/7 "2021-09-16T22:13:31Z")
Also, if you are looking to convert that decimal value to a friendly format, then you can check this out. It’s not a one column or no column solution, but would work without Google sheets. I don’t really trust setting column formats in Google sheets anyway. > [@Time duration not presenting correctly in glide chart stopwatch](https://community.glideapps.com/t/time-duration-not-presenting-correctly-in-glide-chart/24014/6): > > I took it a step further and included Days as well. You can exclude it if you don’t need it. It’s a little involved, but I’ll explain the best I can. Here is my results: First we have the Duration column, which is obvious and what you already have. Next we have the Days column: FLOOR(D)/100 This is simply taking the duration and dropping off the decimals. The division by 100 will be explained later. Next we have the Hours column: FLOOR(MOD(D,1)\*24)/100 Th… If you can capture the start time, current time, and the duration, then you can do the math to get a total duration at the time of capture. --- _[View the full topic](https://community.glideapps.com/t/view-the-duration-of-the-stopwatch-in-usc/31874)._