Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unix Time Function
Is there a function that can convert 4/21/2005 10:43 to unix time like
1116910800? |
#2
|
|||
|
|||
See a couple of answers in .misc
PLEASE don't post the same message to multiple groups. It tends to fragment any answers you get, and potentially wastes the time of those providing solutions that others have provided. For tips on using these groups effectively, see http://cpearson.com/excel/newposte.htm In article , "jnorton" wrote: Is there a function that can convert 4/21/2005 10:43 to unix time like 1116910800? |
#3
|
|||
|
|||
=TEXT( A1*86400-DATE(1970,1,1)*24*60*60,"0000000000")
I have texted it as it is too long for an Excel number display -- HTH Bob Phillips "jnorton" wrote: Is there a function that can convert 4/21/2005 10:43 to unix time like 1116910800? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
What function do I use to convert "time" to minutes? | Excel Worksheet Functions |