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.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Community Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums