JoeCroqueta

Excel

Jul 20th, 2011
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. -- Convertir UNIX epoch a fecha en Excel
  2.  
  3. =(((E2-(6*3600))/86400)+25569)
  4.  
  5. E2 = cell reference
  6. 6 = Timezone Offset (this is Central Standard time)
  7. 3600 = Number of seconds in an hour
  8. 86400 = Number of seconds in a year
  9. 25569 = Excel hack because excel counts epoch from 1/1/1900 and most others start at 1/1/1970.
Advertisement
Add Comment
Please, Sign In to add comment