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”]