|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 24th, 2005, 05:51 PM
|
|||
|
|||
Unix Time Function
Is there a function that can convert 4/21/2005 10:43 to unix time like
1116910800? 
|
|
#2
May 24th, 2005, 05:57 PM
|
|||
|
|||
|
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
May 24th, 2005, 06:04 PM
|
|||
|
|||
|
=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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatically up date time in a cell | Mark | General Discussion | 5 | May 12th, 2005 12:26 AM |
| clock | Wildman | Worksheet Functions | 2 | April 26th, 2005 10:31 AM |
| Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
| Excel Time Function | Claire | Worksheet Functions | 3 | May 11th, 2004 09:51 PM |
| Time Sheet function | John Logan | Worksheet Functions | 3 | October 7th, 2003 07:26 AM |
Linear Mode
