Convert seconds to hh:mm:ss format IN EXCEL
Use =A1/86400 Where A1 holds the time. Format as hh:mm:ss or whatever you need. You can also try A1=9084 B1==TEXT(A1/(24*60*60),”hh:mm:ss”) [xyz-ihs snippet=”Discuss”]
Use =A1/86400 Where A1 holds the time. Format as hh:mm:ss or whatever you need. You can also try A1=9084 B1==TEXT(A1/(24*60*60),”hh:mm:ss”) [xyz-ihs snippet=”Discuss”]