Forum Discussion
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...
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:
- 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.
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?