Forum Discussion
robrobrobrob
Dec 21, 2022Copper Contributor
difference between dates calculated column
hi guys ... i have a sharepoint online list with a column named Begin that marks the creation time of a ticket and i created another calculated column named End that timestamps the ticket when the...
RobElliott
Dec 22, 2022Silver Contributor
robrobrobrob try it with =IF(OR(ISBLANK([End]),ISBLANK([Begin])),"",TEXT([End]-[Begin],"hh:mm"))
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)