02-14-2018
Quote:
Originally Posted by
RudiC
Nice!
But, help me out - how did you derive the 25569 "EXCEL correction summand"? That would represent 03.01.70 00:00 (Jan 3rd), NOT the epoch 1970/01/01 01:00:00, which in turn would be 25567.0416666667 - IF (!) EXCEL's date base were set to 01/01/1900, not the other (more usual?) 01/01/1904.
That's why I proposed to have EXCEL interpret the string so all the local setting were taken into account...
I used the worked example in the OP that stated:
2016-10-11 07:01:23.375 = 42,654.2920446
So I knew that epoch date used in the OPs system was 01-01-1900, and not the Excel 2008 for OSX, default of 01-01-1904, which I believe requires 24107 (not 25567.0416666667)
Last edited by Chubler_XL; 02-14-2018 at 07:46 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello all
im looking for fast way to convert timestamp format to date format
and vaiseversa in tcsh , can it be done?
thanks allot (2 Replies)
Discussion started by: umen
2 Replies
2. Shell Programming and Scripting
Hi guys,
I know that this topic has been discuss numerous times, and I have search the net and this forum for it.
However, non able to address the problem I faced so far.
I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies
3. Shell Programming and Scripting
Hi, I need to convert a date in the format
yyyy-mm-dd to unix seconds, shell script or perl would be ok
since there is no hour/second, we can assume 12am every day
thanks in advance
funksen (4 Replies)
Discussion started by: funksen
4 Replies
4. Shell Programming and Scripting
Hi,
Is there any easy way to convert date time(stored in shell variable ) to epoch time in solaris box? As +%s is working on linux but not on solaris, also -d option is not working.
Any suggestion please? (6 Replies)
Discussion started by: anshuman0507
6 Replies
5. Shell Programming and Scripting
Hi All,
I have a string like below.
"Mar 31 2009" .
I want to convert this to unix time .
Also please let me know how to find the unix time for the above string minus one day. For Eg. if i have string "Mar 31 2009" i want to find the unix time stamp of "Mar 30 2009".
Thanks in advance,... (11 Replies)
Discussion started by: girish.raos
11 Replies
6. Shell Programming and Scripting
Hi,
I have a file file1 having data as below
20110501,070742, ,012345678909,09999999999,68.5,
20110501,070236, ,089375855455,09376383333,374.3,
20110501,070525, ,090345895555,08444233444,206.2,
20110501,230051, ,000934744433,07624262223,480.1,
First field is date(YYYYMMDD) and second... (5 Replies)
Discussion started by: vsachan
5 Replies
7. Shell Programming and Scripting
Hi,
In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date×tamp. I have to figure out the the data is a date or time stamp or date×tamp.
If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies
8. AIX
hello,
i have an AIX5.3 machine and i am writing a script to display some processes.
inside the script i want to get the time that the process starts and convert it to a unix timestamp.
is there a command that i can use to do that? i search the web but all i found is long scripts and it does... (4 Replies)
Discussion started by: omonoiatis9
4 Replies
9. Shell Programming and Scripting
Hello All,
I have a date in DD/MM/YYYY format. I am trying to convert this into unix timestamp. I have tried following:
date -d $mydate +%s
where mydate = 23/12/2016 00:00:00
I am getting following error:
date: extra operand `+%s'
Try `date --help' for more information.
... (1 Reply)
Discussion started by: angshuman
1 Replies
10. Shell Programming and Scripting
I am trying to hit an URL using below command and get the data into an excel sheet.
wget --user=<<USERID>> --pass=<<PASSWROD>> http://www.files.thatbelongstome.com/file1 -O test1.xls
Next step is to consolidate files from 1 to 10 in a single excel sheet and send to my mail. I am working on... (1 Reply)
Discussion started by: PikK45
1 Replies
LEARN ABOUT FREEBSD
getdate
GETDATE(1) User Commands GETDATE(1)
NAME
getdate - AME
SYNOPSIS
[-dv][-n dec][-f format] [ra dec sys] itype2otype [date and/or time]
DESCRIPTION
Convert date and time between various formats
[-dv][-n dec][-f format] itype2otype @file
itype: nfd=ISOFITS fd=FITS, dt=yyyy.mmdd, hr=hh:mm:ss, deg=dd:mm:ss
jd=Julian Date, mjd=Modified Julian Date hjd=Heliocentric Julian Date, mhjd=Modified HJD ep=epoch, epj=Julian epoch, epb=Besselian
epoch lt=local time, ut=UT, ts=seconds since 1950-01-01 now=current time, ang=fractional degrees
otype: fd=FITS, dt=yyyy.mmdd, jd=Julian Date, mjd=Modified Julian Date
hjd=Heliocentric Julian Date, mhjd=Modified HJD hr=hh:mm:ss, deg=dd:mm:ss, ang=fractional degrees ep=epoch, epj=Julian epoch,
epb=Besselian epoch ts=seconds since 1950-01-01, tsu=Unix sec, tsi=IRAF sec gst=Greenwich Sidereal Time, lst=Local Sidereal Time
@file: First one or two columns are in itype format ra dec sys: Need for Heliocentric conversions
-a: Append date to input file, if there is one
-d: Print date without time
-e: Print output as ET/TDT/TT converting from UT
-f: Format for output number (C printf)
-h hours: Longitude in hours, west positive
-l degrees: Longitude in degrees, west positive
-n: Number of decimal places in sec, epoch, JD
-t: Print time without date
-v: Verbose
getdate 3.8.4 June 2012 GETDATE(1)