# Formulas with two time columns \[Jan 01\] **URL:** \ **Category:** Discord-Discussions\ **Created:** [November 3, 2022, 7:53am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179 "2022-11-03T07:53:53Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:53am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/1 "2022-11-03T07:53:53Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _asked_ ## Hey - Is it possible to calculate the duration from two time columns with formulars? ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:53am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/2 "2022-11-03T07:53:54Z")
> ๐Ÿ’ **o1lab** _replied_ #### [https://docs.nocodb.com/setup-and-usages/formulas#functions](https://docs.nocodb.com/setup-and-usages/formulas#functions) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:53am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/3 "2022-11-03T07:53:55Z")
> ๐Ÿ’ **o1lab** _replied_ #### weโ€™ve above functions available as of now # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:53am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/4 "2022-11-03T07:53:57Z")
> ๐Ÿ’ **o1lab** _replied_ #### like by duration - you need in minutes you are saying ? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:53am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/5 "2022-11-03T07:53:58Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _replied_ #### best would be in decimal # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:53am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/6 "2022-11-03T07:53:59Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _replied_ #### like 0,5 for half an hour # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/7 "2022-11-03T07:54:00Z")
> ๐Ÿ’ **o1lab** _replied_ #### to understand it clear, the duration b/w two columns is possible but its not decimal - correct ? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/8 "2022-11-03T07:54:01Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _replied_ #### i think there should be a way if the columns are not formatted in any way # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/9 "2022-11-03T07:54:03Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _replied_ #### In Spreadsheet i would do something like: #### =HOUR(A2) + MINUTE(A2)/60 + SECOND(A2)/3600 # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/10 "2022-11-03T07:54:04Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _replied_ #### ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/optimized/1X/72ed999dbd8360721b0946f575650d8e65f08a86_2_690x30.png) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/11 "2022-11-03T07:54:05Z")
> ๐Ÿ’ **o1lab** _replied_ #### if you could pls raise an issue with details - we will look into it # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/12 "2022-11-03T07:54:06Z")
> ๐Ÿ’ **o1lab** _replied_ #### [Sign in to GitHub ยท GitHub](https://github.com/nocodb/nocodb/issues/new?assignees=&labels=&template=bug_report.md&title=) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/13 "2022-11-03T07:54:08Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _replied_ #### ok - thanks # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/14 "2022-11-03T07:54:09Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _replied_ #### You really think this is a bug? I assume i just get things wrong here # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/15 "2022-11-03T07:54:10Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _replied_ #### but anyway i will open an issue tomorrow # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/16 "2022-11-03T07:54:11Z")
> ๐Ÿ’ **o1lab** _replied_ #### alright, its not a bug ๐Ÿ™‚ # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/17 "2022-11-03T07:54:12Z")
> ๐Ÿ’ **o1lab** _replied_ #### we will assign it accordingly # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/18 "2022-11-03T07:54:14Z")
> ๐Ÿ™‹โ€โ™‚๏ธ **Rabbit** _replied_ #### ok # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/19 "2022-11-03T07:54:15Z")
> ๐Ÿ’ **o1lab** _replied_ #### we need steps and details # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 7:54am UTC](https://community.nocodb.com/t/formulas-with-two-time-columns-jan-01/179/20 "2022-11-03T07:54:16Z")
[Autogenerated from discord](https://discord.com/channels/661905455894888490/926512329330405386) * * * #### Join [NocoDBโ€™s](http://www.nocodb.com/) community [Discord](https://discord.gg/5RgZmkW) โ€ข [Twitter](https://twitter.com/nocodb) โ€ข [Reddit](https://www.reddit.com/r/NocoDB/) โ€ข [Docs](https://docs.nocodb.com/)