How do I add 4 hours 59 minutes to this Time1 Table - Record IDTime1106:44:39206:19:32306:19:13406:19:16506:19:07606:11:09 In such a way the result will be in HH:mm:ss format.

Time Add

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.

Workflow

Help

Accepted answers

Jean-Balteryx

Hi @henrygeorge ,

I modified the workflow from the previous post !

Cheers,

Jean-Baptiste

Time Difference.yxmd

All comments

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

Hi @henrygeorge ,

I modified the workflow from the previous post !

Cheers,

Jean-Baptiste

Time Difference.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703