There are 86400 seconds in a day.
30134/86400 = 0.34877
Therefore, you can format a cell containing 0.34877 as "Time" to display "8:22:14 AM"
(or a cell containing the formula... =30134/86400)
--
Jim Cone
Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware
(Data Options add-in: rows/dates/random stuff)
"slscanlon3" <[email protected]>
wrote in message
news:cb2ef8b1-7d8f-4490-b046-88ed30f156f1@vy8g2000pbc.googlegroups.com...
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
