 SOLVED

# How to calculate time duration

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

# Re: How to calculate time duration

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

# Re: How to calculate time duration

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

# Re: How to calculate time duration

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