How to add or subtract time in nocodb i [Jun 19]

:raising_hand_man: sidheequesdq asked

how to add or subtract time in nocodb, i need duration on my table. its possible? like starting time is 1:30 ending time is 2:00 = duration is 30. please help

:raising_hand_man: sidheequesdq replied

anyone?

:raising_hand_man: wkw replied

<@493161649377902613> which db r u using

:raising_hand_man: wkw replied

Formula: ({T2} - {T1})

image0

:raising_hand_man: wkw replied

in PG.

:raising_hand_man: sidheequesdq replied

Thanks.

:raising_hand_man: sidheequesdq replied

its possible get a numeric value only. like just 15.

:raising_hand_man: wkw replied

i think not. in fact, there should be some enhancement on it as mysql would give different format

Autogenerated from discord


Join NocoDB’s community

Discord • Twitter • Reddit • Docs