I have two date columns in a custom list: Start time and End time, both are set to today's date and just select the time.
Now I want to add a new column that will automatically show the subtraction of End time from Start time.
How can this be done?
-
Start with how you do it in Excel, most basic calculations are the same in SP– Danny '365CSI' EngelmanApr 26, 2017 at 11:56
-
Shout out to @Danny'365CSI'Engelman, this is a great resource: viewmaster365.com/365coach/#/Calculated_Column_Functions_List– Flat BananaApr 26, 2017 at 13:24
Add a comment
|
1 Answer
You can do this:
=INT(([End Date]-[Start Date])*1440)
Answer here also: Get difference in Minutes for DateTime format column
answered Apr 26, 2017 at 22:16
