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.
Solved! Go to Solution.
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
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