Forum Discussion

AloisOhZH's avatar
AloisOhZH
Copper Contributor
Nov 19, 2020

Calculate Time difference in calculated column

Hi all, How do i calculate the time difference between time delivered and time accepted. Both of the columns are single line of text. My time taken column is a calculated single line of text ty...
SharePoint Online
AloisOhZH's avatar
AloisOhZH
Copper Contributor

Hi ganeshsanap ,

Both my time accepted and time delivered are single line of text because in my powerapps, I use Now() function to capture the time and date. Now that I want to calculate the time difference, I referred to the formula you sent. It returns an error.


Regards,
Alois

ganeshsanap's avatar
ganeshsanap
MVP
Nov 20, 2020

AloisOhZH 

You can save Now() from Power Apps to SharePoint date and time fields, check below reference:

Sending Date and Time to SharePoint Column Type Date and Time 

 

Also, what is the error you are getting using above formula? 

 

Note:

  1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

For correct syntax, check this: Calculate the difference between two times 

Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

 

  • rispazia's avatar
    rispazia
    Copper Contributor
    Apr 24, 2021

    Hi ganeshsanap ,

    I tried what u seggest but I get an error with both comma (,) and semicolon (;). Do u have any other trick to share?

     

     

     

     

Resources