Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Timestamp | Excel Discussion (Misc queries) | |||
Timestamp | Excel Discussion (Misc queries) | |||
Now as timestamp | Excel Worksheet Functions | |||
timestamp functions | Excel Worksheet Functions | |||
Timestamp Button | Excel Discussion (Misc queries) |