General discussion

Locked

Easy Excel Conversion: seconds to hh:mm:ss

By stephen.berry ·
Enter the following formula in the cell where you want to see the converted time: =+BF35/0.04166666666666664
Then replace B35 with the cell that contains the seconds you are converting and format the cell to Time of type '37:30:55'

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums