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.

enter image description here

For more detailed information, refer to the article below.

SharePoint Calculate difference between two dates.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.