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.





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


But with this formula doesn't work :\


Someone have solution?

3 Replies
Does this help
May depend on the format of your two columns.
best response confirmed by Antonio_Savage11 (Occasional Contributor)
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