Forum Discussion

Copper Contributor

Aug 17, 2023

Column Calculation: Dates

Hi, So I am using this for the calculation: =IF(ISBLANK([Completed Date]),0,IF([Completed Date]>=[Start Date],DATEDIF([Start Date],[Completed Date],"d"),"Invalid Date")) I would like to ha...

Silver Contributor

Aug 30, 2023

username1231231885 make sure your date/time columns are set to time as well as date then use something similar to the following formula in your calculated column to give you the fraction of a full day (24 hours). The calculated column has a number output with 1 decimal place.

=INT([End Date]-[Start Date])+HOUR([End Date]-[Start Date])/24

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform (and classic 1967 Morris Traveller driver)