Excel: seconds in hours:minutes:seconds

root's picture

What if you have values in seconds and you would like to know how much time is there directly?
Simple!

1. On the cell where you want to see calculated time

let's say B1, right click -> "Format Cells..." and there go to "Number" and on "Category" select "Custom" and as type select hh:mm:ss.
NOTE: my advice is to add hh (hours) too because if you have seconds more than one hour, you will see only the minutes after the hour and is wrong (e.g. 7144s = 01:59:04 for hh:mm:ss and 59:04 for mm:ss)

2. Add your seconds in another cell

Let's call it B2

3. On the cell B1, add this value

=IFERROR(B2/(60*60*24), "")
NOTE: IFERROR will show nothing if you do not have any value in B2 yet).

DONE ;)

Thou shalt not steal!

If you want to use this information on your own website, please remember: by doing copy/paste entirely it is always stealing and you should be ashamed of yourself! Have at least the decency to create your own text and comments and run the commands on your own servers and provide your output, not what I did!

Or at least link back to this website.

Recent content

root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root
root