SOLVED

How to calculate time duration

Occasional Contributor

Hi guys,

 

I hope you are doing well

 

How can i calculate the time duration of the time 1 and time 2? in this case i have 21 seconds of duration.

 

Antonio_Savage11_1-1643817622187.png

 

 

Formula of the column "Duration": =TEXT(time2-time1)

 

But with this formula doesn't work :\

 

Someone have solution?

3 Replies
Does this help
Duration=TEXT(time2-time1,"ss")
May depend on the format of your two columns.
best response confirmed by Antonio_Savage11 (Occasional Contributor)
Solution
Hi i solve this with these steps:

1- Format my Time 1 and Time 2 as text , and create other column with calculation in text format with calculated formula: =TEXT([End Time]-[Start Time],"h:mm:ss")

Thank you
I tried this suggestion, but it didn't work. the cell with the formula simply showed the formula and did not create the time difference. all three cells were formatted as ''Text.
Thanks for any help.
Frank Hudson