How to calculate time duration

[Antonio_Savage11]

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.

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

But with this formula doesn't work :\

Someone have solution?

[#2]

Does this help
Duration=TEXT(time2-time1,"ss")
May depend on the format of your two columns.

[#3 · Accepted 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

[#4]

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