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

For any query or issue, feel free to discuss on http://discuss.eduguru.in

Leave a Reply