julian time or other time?

[DGRL]

Dear coders

 

Excel if screwing around again and i am trying to find a nice solution for it for all of us

 

When reading the date from excel i get back amound of days from a specific year 10-23-2017 ( 43030 )

IS there a LSP file who can calculate these days back into readable date?

[Stefan BMR]

There are many variations of the Julian Date.

Excel uses JD-2415020.

You can get the correct date from excel with this:

(menucmd (strcat "m=$(edtime," (rtos (+ 2415020.0 43030)) ",MO-DD-YYYY)")) -> "10-23-2017"

[DGRL]

except for the formatting ( I can fix that in expensive way but I rather add ' to the excel cell that contains the date in order to keep the formatting ) this is perfect

Thanks

[Lee Mac]

except for the formatting ( I can fix that in expensive way but I rather add ' to the excel cell that contains the date in order to keep the formatting )

 

Here is a reference for the edtime DIESEL function - you can change the 'picture' (currently "MO-DD-YYYY") to whatever you require.

[Roy_043]

This may be of interest:

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-text-property-excel

https://www.mrexcel.com/forum/excel-questions/51310-getting-formatted-cell-value-rather-than-raw-data-through-vb.html

[DGRL]

Thanks guys for the info

I think I can work things out

 

(issue

 

 

I get 1 excel file with dates in it and I do not know the format

Read out excel fill in txt strings in model

format of date needs to remain the same

So I need to read the format of the cell and apply that

 

 

I can make something for that

[Lee Mac]

You should be able to obtain the plain text content of the Excel cell, as opposed to the value - see this example.

[DGRL]

Again out of this world Lee Mac comes with a piece of code I can use.

:notworthy:

:notworthy:

:notworthy:

 

 

#cadtutor please rename this emoticon from not worthy to worthy

[Grrr]

see this example.

 

Basically from where I started learning on Excel scripting.

[DGRL]

I want to become an apprentice of Lee Mac and maybe in the near future I can call myself a programmer also

[rlx]

I want to become an apprentice of Lee Mac and maybe in the near future I can call myself a programmer also

 

 

How about the Lee Mac University , has a nice ring to it , n'est pas? :-)

[Grrr]

I want to become an apprentice of Lee Mac and maybe in the near future I can call myself a programmer also

 

First you learn how to LISP, then you learn from him how to LeeSP.

Thats like switching from basic to advanced level.