Forum Discussion
Solved
Calculate a duration in column formatting
How can I calculate a duration in column formatting? With calculated columns, I can calculate a duration in days by subtracting two dates. For example if Start is 9/2/2018 and End is 1/31/2019, E...
I found a solution with the help of another thread.
The Number() operator converts a date into millisaconds. So the formula I came up with in column formatting is:
"=(Number([$End])-Number([$Start]))/1000/60/60/24"
I found a solution with the help of another thread.
The Number() operator converts a date into millisaconds. So the formula I came up with in column formatting is:
"=(Number([$End])-Number([$Start]))/1000/60/60/24"