Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Convertir UNIX epoch a fecha en Excel
- =(((E2-(6*3600))/86400)+25569)
- E2 = cell reference
- 6 = Timezone Offset (this is Central Standard time)
- 3600 = Number of seconds in an hour
- 86400 = Number of seconds in a year
- 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