Formulas with two time columns [Jan 01]

:raising_hand_man: Rabbit asked

Hey - Is it possible to calculate the duration from two time columns with formulars?

:person_tipping_hand: o1lab replied

https://docs.nocodb.com/setup-and-usages/formulas#functions

:person_tipping_hand: o1lab replied

we’ve above functions available as of now

:person_tipping_hand: o1lab replied

like by duration - you need in minutes you are saying ?

:raising_hand_man: Rabbit replied

best would be in decimal

:raising_hand_man: Rabbit replied

like 0,5 for half an hour

:person_tipping_hand: o1lab replied

to understand it clear, the duration b/w two columns is possible but its not decimal - correct ?

:raising_hand_man: Rabbit replied

i think there should be a way if the columns are not formatted in any way

:raising_hand_man: Rabbit replied

In Spreadsheet i would do something like:

=HOUR(A2) + MINUTE(A2)/60 + SECOND(A2)/3600

:raising_hand_man: Rabbit replied

:person_tipping_hand: o1lab replied

if you could pls raise an issue with details - we will look into it

:person_tipping_hand: o1lab replied

Sign in to GitHub · GitHub

:raising_hand_man: Rabbit replied

ok - thanks

:raising_hand_man: Rabbit replied

You really think this is a bug? I assume i just get things wrong here

:raising_hand_man: Rabbit replied

but anyway i will open an issue tomorrow

:person_tipping_hand: o1lab replied

alright, its not a bug :slightly_smiling_face:

:person_tipping_hand: o1lab replied

we will assign it accordingly

:raising_hand_man: Rabbit replied

ok

:person_tipping_hand: o1lab replied

we need steps and details

Autogenerated from discord


Join NocoDB’s community

DiscordTwitterRedditDocs