# How to format time code

**URL:** <https://connect.superhuman.com/t/how-to-format-time-code/48378>\
**Category:** Ask the Community\
**Created:** [May 2, 2024, 6:51am UTC](https://connect.superhuman.com/t/how-to-format-time-code/48378 "2024-05-02T06:51:29Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Erik\_van\_Schaaik](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/erik_van_schaaik/32/20763_2.png) [@Erik\_van\_Schaaik](https://connect.superhuman.com/u/Erik_van_Schaaik)\
**Post date:** [May 2, 2024, 6:51am UTC](https://connect.superhuman.com/t/how-to-format-time-code/48378/1 "2024-05-02T06:51:29Z")

</div>

Hi,

I would like to format a column for video time code, so I can sum up the duration of a list of shots.

A time code consists of hours : minute : seconds : frames (00:01:20:24)

There are 24 frames in a second (for film) or 25 frames in a second (for video). So I would like to be able to set the fps (frames per second) for a project.

How to go about this…?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![boonshin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/boonshin/32/40931_2.png) [@boonshin](https://connect.superhuman.com/u/boonshin)\
**Post date:** [May 2, 2024, 8:52pm UTC](https://connect.superhuman.com/t/how-to-format-time-code/48378/2 "2024-05-02T20:52:49Z")

</div>

Here’s one way to do it. The idea is to convert them to frames when summing them up and then convert them back to timecode. I kept things simple and did not take into account DF / NDF.

https://coda.io/embed/cPOYo8-P5x/_suRlU?viewMode=embedplay&hideSections=true

---

<div class="post-metadata">

**Author:** ![Erik\_van\_Schaaik](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/erik_van_schaaik/32/20763_2.png) [@Erik\_van\_Schaaik](https://connect.superhuman.com/u/Erik_van_Schaaik)\
**Post date:** [May 3, 2024, 1:01pm UTC](https://connect.superhuman.com/t/how-to-format-time-code/48378/3 "2024-05-03T13:01:33Z")

</div>

I am afraid I don’t follow. And the embed is ‘not found’. So…  
Thanks anyway.

---

<div class="post-metadata">

**Author:** ![boonshin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/boonshin/32/40931_2.png) [@boonshin](https://connect.superhuman.com/u/boonshin)\
**Post date:** [May 3, 2024, 4:48pm UTC](https://connect.superhuman.com/t/how-to-format-time-code/48378/4 "2024-05-03T16:48:46Z")

</div>

Apologies @Erik_van_Schaaik. I just updated the permissions. Let me know if you can see the doc now.

---

<div class="post-metadata">

**Author:** ![Erik\_van\_Schaaik](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/erik_van_schaaik/32/20763_2.png) [@Erik\_van\_Schaaik](https://connect.superhuman.com/u/Erik_van_Schaaik)\
**Post date:** [May 4, 2024, 6:54am UTC](https://connect.superhuman.com/t/how-to-format-time-code/48378/5 "2024-05-04T06:54:40Z")

</div>

Yes, it is working! And what a great way of setting it up. Thank you so much!

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [May 7, 2024, 6:55am UTC](https://connect.superhuman.com/t/how-to-format-time-code/48378/6 "2024-05-07T06:55:29Z")

</div>

Closed on May 7, 2024, 6:55am UTC

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.