Forum Discussion
Substraction of date and time in calculated column
Hello, what I have problem with is the substraction of date and time in calculated column. I have two "date and time" columns and I have no idea what formula should I use to substract these columns....
ocin33 =IF(OR(ISBLANK([Awaria Stop]),ISBLANK([Awaria Start])),"",TEXT([Awaria Stop]-[Awaria Start],"hh:mm"))
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott , thank you. It works if it comes o the time but how can we add days or number of hours that take the difference between days into consideration?
The result in the second row should be 48h 30min 😕
