# Calculate time from duration **URL:** \ **Category:** Ask for Help\ **Created:** [December 18, 2023, 10:17am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798 "2023-12-18T10:17:53Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 10:17am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/1 "2023-12-18T10:17:53Z")
Is it possibe to calculate duration by subtracting the start time from the end time, I saw how to use the math column to subtract duration from a start time to get end time on this thread ([How to calculate hours worked from Start time and End time](https://community.glideapps.com/t/how-to-calculate-hours-worked-from-start-time-and-end-time/44392)) and that works but not vice versa. If I use the math column for the reverse caIculation, the answer is blank. I would what the answer returned to be in the form of HH:MM:SS. Thanks in advance for your assitance ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2023, 10:37am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/2 "2023-12-18T10:37:16Z")
> [@Keith\_Chikumbirike](#): > > I would what the answer returned to be in the form of HH:MM:SS. That’s exactly what `End - Start` will give you in a Math column. If that’s not what you get, please show a screen shot of the columns from the Data Editor. ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 11:05am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/3 "2023-12-18T11:05:40Z")
Maybe failing to configure the format of the duration column such that I am not getting the accurate date and time as I should. Rather I want to get time when I add duration to start time. **I didnt explain well at first**. An example would be; a speech starts at 12noon, the speech is intended to last for 00:15:00 then next segment should start at 1215hrs. ![Screenshot (146)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/29372c777a420bd5dc452675594c4e5accce4502.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2023, 11:07am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/4 "2023-12-18T11:07:21Z")
I’m confused. What exactly are you trying to do? ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 11:09am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/5 "2023-12-18T11:09:50Z")
my apoligoies, didnt explain it well at first. I want end time by adding duration to start time ![Screenshot (151)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3ded1763a8c19410cdcadfd7426acb6e8131eda9.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2023, 11:13am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/6 "2023-12-18T11:13:05Z")
Okay, so `Start + Duration` should work. ![CleanShot 2023-12-18 at 19.12.35@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b706eecd58a2c8905544320e39a9c69d5c343419.png) ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 11:15am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/7 "2023-12-18T11:15:04Z")
So your end is a math column? How would i achieve that, i would want to populate that end time column from a form submission ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2023, 11:16am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/8 "2023-12-18T11:16:35Z")
Yes, exactly the same as yours. Note that the duration shown in your earlier screen shot is `14400:00:00` That’s 14,400 hours, which is 600 days. So the result you are getting is correct. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2023, 11:18am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/9 "2023-12-18T11:18:25Z")
> [@Keith\_Chikumbirike](#): > > i would want to populate that end time column from a form submission Which values are you collecting in the form? I assume Start Time and Duration? If that’s the case, your math column should calculate the End Time as each row is added. ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 11:20am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/10 "2023-12-18T11:20:27Z")
Yes…those are the columns exatly ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 11:21am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/11 "2023-12-18T11:21:26Z")
yes…now this is for event program so a typical segment duration is in minutes…so i shoul create a math column to divide the input of duration? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2023, 11:26am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/12 "2023-12-18T11:26:26Z")
Okay, you might be better off taking a different approach, because the Duration column takes days as input and converts it to HH:MM:SS. So for example, to enter 25 minutes your user would need to enter 0.0173611 (25/1440), which is not very practical. I would suggest instead collect the duration in minutes in a Number column, and then use that to calculate the End Time using `Start + Duration/1440` ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 11:32am UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/13 "2023-12-18T11:32:48Z")
it worked! many thanks ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 12:34pm UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/14 "2023-12-18T12:34:19Z")
Now would it be possible to convert the outcome to a time only value in a different column? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2023, 12:34pm UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/15 "2023-12-18T12:34:52Z")
In which format? ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 12:39pm UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/16 "2023-12-18T12:39:13Z")
HH:MM:SS format ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2023, 12:42pm UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/17 "2023-12-18T12:42:11Z")
Assuming that the user is entering a duration in minutes, use a math column to convert that to seconds (multiply by 60), and then pass that value to a Format Duration column. ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 12:54pm UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/18 "2023-12-18T12:54:59Z")
You mean the duration? its in date and time format so when i multiple with 60 the math is not working ![Screenshot (152)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e5a26d8dcf107409f6b597f4f283731039b97d2.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2023, 12:57pm UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/19 "2023-12-18T12:57:45Z")
I thought you were using a Number column to capture the Duration in minutes? That’s the column that should be multiplied by 60. ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 18, 2023, 1:19pm UTC](https://community.glideapps.com/t/calculate-time-from-duration/68798/20 "2023-12-18T13:19:36Z")
Yes but what needs conversion is the actual date and time to time only (HH:MM:SS) [Next page](https://community.glideapps.com/t/calculate-time-from-duration/68798.md?page=2)