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

Discord-Discussions
1

: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

2

:raising_hand_man: sidheequesdq replied

anyone?

3

:raising_hand_man: wkw replied

<@493161649377902613> which db r u using

4

:raising_hand_man: wkw replied

Formula: ({T2} - {T1})

image0

5

:raising_hand_man: wkw replied

in PG.

6

:raising_hand_man: sidheequesdq replied

Thanks.

7

:raising_hand_man: sidheequesdq replied

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

8

:raising_hand_man: wkw replied

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

9

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs