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
ganeshsanap's avatar
ganeshsanap
MVP
Nov 19, 2020

AloisOhZH 

Can you please share the formula you are currently using for "Time Taken"?

That will help us to identify the issue with formula and answer your question more precisely.

 

Also, why are you using single line of text fields for Time Accepted and Time Delivered?

 

General format for your formula should something be like:

=TEXT(DATE([Column2])-DATE([Column1]),"h:mm:ss")

Reference: Date and time formulas 

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.

 

RobElliott's avatar
RobElliott
Silver Contributor
Nov 20, 2020

ganeshsanap as you have the dates & times in Power Apps you could just do the DateDiff calculation in Power Apps then save the result to the SharePoint list item.

 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Resources