![]() |
Labview timestamp conversion
does anyone know how to convert the labview timestamp to the typical date and
time? for example I have 3256330684.23 which is March 10 2007 (and I forget what time of day it was) thanks |
Labview timestamp conversion
ooops the date is actually March 8 2007
hope this helps "BillO" wrote: does anyone know how to convert the labview timestamp to the typical date and time? for example I have 3256330684.23 which is March 10 2007 (and I forget what time of day it was) thanks |
Labview timestamp conversion
=A1/(3600*24)+--("1/1/1904")
I think you were right first time with 10/3/07. But you may need to correct for timezone. -- David Biddulph "BillO" wrote in message ... ooops the date is actually March 8 2007 hope this helps "BillO" wrote: does anyone know how to convert the labview timestamp to the typical date and time? for example I have 3256330684.23 which is March 10 2007 (and I forget what time of day it was) thanks |
Labview timestamp conversion
Thanks that just made life a lot easier.
"David Biddulph" wrote: =A1/(3600*24)+--("1/1/1904") I think you were right first time with 10/3/07. But you may need to correct for timezone. -- David Biddulph "BillO" wrote in message ... ooops the date is actually March 8 2007 hope this helps "BillO" wrote: does anyone know how to convert the labview timestamp to the typical date and time? for example I have 3256330684.23 which is March 10 2007 (and I forget what time of day it was) thanks |
All times are GMT +1. The time now is 01:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com