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?
1 Answer
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.
-
is there someway to show negative values using text formatting, eg
TEXT(Finish-Start, “h:mm”). more specifics are in my question here if anyone can help: sharepoint.stackexchange.com/q/281535 Commented Jun 13, 2020 at 12:50