I need to calculate a difference between two times and it should show negative value if the value is negative. Say Time 1 is 29/04/2019 11:30 PM and Time 2 is 29/04/2019 12:00 PM. I wat the difference shown as -11.50. Can someone help on this?
If you want to show negative value when calculating two dates, you could configure the calculated column as below, select “Number” as the data type returned from this formula.
For more detailed information, refer to the article below.