MrExcel Publishing
Your One Stop for Excel Tips & Solutions

converting seconds to exact time

Posted by Mike on November 23, 2001 7:39 AM

Excel makes it easy to convert time to exact seconds. For example, when formatting time with the [ss] option,
11/19/01 11:20 AM converts to 3215348401
12:14 PM converts to 44059.
What I'm having trouble with, is I'm getting exact seconds from a unix server, and wanting excel to convert that back to an exact time. It this feature even possible?!
Pulling my hair out!!
Thanks for any help

Posted by IML on November 23, 2001 8:10 AM

Try unix seconds divided by 86400 and see if that give you what you want. (format it to time)