Community archive

Ask something
Discussion Locked

Easy Excel Conversion: seconds to hh:mm:ss

0 helpful
0 replies

by stephen.berry

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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'

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.