hat
nòt: Isit la se yon lòt fòmil tou ka ede w montre kantite segonn kòm fòma tèks sa a: x èdtan x minit x segonn: = TEXT (A2 / 86400, CHWAZI (MATCH (A2, {0,60,3600}, 1), "s" "sec" "," m "" min "" s "" sec "", "[h]" " hrs "" m "" min "" s "" sec "" ")), apre yo fin aplike fòmil sa a, ou pral jwenn rezilta sa a, gade D:
eng
Note: Here is another formula also can help you to display the number of seconds as the text format like this: x hours x minutes x seconds: =TEXT(A2/86400,CHOOSE(MATCH(A2,{0,60,3600},1),"s ""sec""","m ""min"" s ""sec""","[h] ""hrs"" m ""min"" s ""sec""")), after applying this formula, you will get this result, see screenshot: