I have a table that i am extracting into excel. One column contains a work log with numerous occurences within a text string where the 10 digit epoch time value is displayed. I am able to pull each one for a conversion, however before i write anything i need to determine a calculation method within VBA to convert the Epoch time value of XXXXXXXXXX into the date and time value of xx/xx/xxxx xx:xx:xx
Has anyone got a function in VBA for excel that will perform this conversion for me and provide me with a text string to visually display the epoch time value as dd/mm/yyyy hh:mm:ss?
Thanks in advance, Jody