Forum Discussion

ocin33's avatar
ocin33
Copper Contributor
Dec 20, 2022

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.

The result should be presented as a time (HH:MM)

Can you help me? 

 

Thanks,

Mateusz

Lists
microsoft lists
SharePoint Online

2 Replies

Sort By
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Dec 20, 2022

    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)

    • ocin33's avatar
      ocin33
      Copper Contributor
      Dec 21, 2022

      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 😕

Resources