Time Add

[henrygeorge]

How do I add 4 hours 59 minutes to this Time1 Table -

Record ID	Time1
1	06:44:39
2	06:19:32
3	06:19:13
4	06:19:16
5	06:19:07
6	06:11:09

In such a way the result will be in HH:mm:ss format.

[afv2688]

Hello @henrygeorge ,

If your column has already the time format you could use the datetimeadd function:

datetimeadd([Time1], 299, 'minutes')

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[OllieClarke]

Hi @henrygeorge the following formula should do it:

datetimeadd('2020-01-01 '+[time1],299,'minutes') 

Ensuring that the datatype is Time

Hope that helps,

Ollie

[Jean-Balteryx · Accepted solution]

Hi @henrygeorge ,

I modified the workflow from the previous post !

Cheers,

Jean-Baptiste