If A1 contains 3661 and B1 contains:
=A1/24/60/60 will display as: 0.042372685
if formatted as hh:mm:ss will display as: 01:01:01
--
Gary's Student
"jsturino" wrote:
> I woul like to find out how to convert seconds into hr:min:sec. For an
> example I would like to take 3661 seconds and convert it into 1hr 1 min 1 sec.
Bookmarks