![\"\"](\"http:\/\/4us2use.at\/wp-content\/uploads\/2018\/10\/DateTimeDiffCalc1-1.png\")
<\/p>\nProblem:<\/p>\n
I needed something like calcDateTimeDiff formula, but wasn’t available in Flow.\u00a0 The data source in my case was a SharePoint list and I wanted to write the time difference (daily work time) back to the list in a string column.<\/p>\n
Solution:<\/p>\n
1. calculate the datetime difference in ticks() format – yes, that’s the trick!
\nOne tick = 1 nanosecond
\nsub(ticks(item()[‘stEnd’]),ticks(item()[‘dtStart’]))<\/p>\n
<\/p>\n
2.\u00a0 Starting the day at 00:00 and add the seconds, then define the output format (1 second = 10.000.000 ns)
\naddSeconds(’00:00:00′,int(div(int(variables(‘testDiffDate’)),10000000)),’HH:mm:ss’)<\/p>\n
Problem: I needed something like calcDateTimeDiff formula, but wasn’t available in Flow.\u00a0 The data source in my case was a SharePoint list and I wanted to write the time difference (daily work time) back to the list in a string column. Solution: 1. calculate the datetime difference in ticks() format – yes, that’s the trick! … <\/p>\n![\"\"](\"http:\/\/4us2use.at\/wp-content\/uploads\/2018\/10\/DateTimeDiffCalc2-1.png\")
<\/p>\n![\"1](\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/stars\/rating_on.gif\" "\\"1")
(2<\/strong> votes, average: 5.00<\/strong> out of 5)
<\/span><\/span>![](\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/loading.gif\")
Loading...<\/span>\n","protected":false},"excerpt":{"rendered":"