On 07/07/2020 00:52, John Kaufmann wrote:
On 2020-07-02 10:22, Philip Jackson wrote:
That said, I concluded that if you and Rémy could not solve the caption
problem, my poor efforts would not be likely to help, but I was most intrigued
by this --
[My current unpredictable behaviour problem
Hi Michael,
Le 07/07/2020 à 14:34, Michael Tiernan a écrit :
On 7/2/20 2:06 PM, Michael D. Setzer II wrote:
I've been trying to take a formula that calculates the difference
between to
dates into years/months/days.
I'll ask if anyone has a macro or formulae that would do almost the same
On 2020-07-07 17:54, Philip Jackson wrote:
On 07/07/2020 00:52, John Kaufmann wrote:
On occasions when I want the Styles and Navigator visible concurrently (that
is, if the Style sidebar's own alternative Navigator function does not
suffice), I leave Styles on the right sidebar and put the
This is the macro for the date to years months day.
Hopefully this posts ok without changes..
sub Z3
rem --
rem define variables
dim document as object
dim dispatcher as object
rem
List is screwing with the messages by removing quotes and some places
spaces?? Send myself a copy of message and it is unmodified? So, assume
is some filter system that is brain dead??
Did a replace of all quotes in macro to ~.
Hopefully, that will go thru, and the other spaces will not be
Testing if this option of sending works??
sub ZT
rem --
rem define variables
dim document as object
dim dispatcher as object
rem --
rem get access to the
Worked on creating a macro, and had to change it to two inputs.
Tried to do the single input, but ran into issues splitting it to change order
and convert , to -?? So simple solution to input each separate.
Hopefully, the email will have the's correctly..
Seems the Server screwed it up again.
Worked on creating a macro, and had to change it to two inputs.
Tried to do the single input, but ran into issues splitting it to change order
and convert , to -?? So simple solution to input each separate.
Hopefully, the email will have the's correctly..
sub ZT
rem
On 7/2/20 2:06 PM, Michael D. Setzer II wrote:
I've been trying to take a formula that calculates the difference between to
dates into years/months/days.
I'll ask if anyone has a macro or formulae that would do almost the same
thing but allow it to be expressed further out to include "hours"
Did a test with the following:
In cell A1 =int(now())
in cell A2 =A1+time(1,12,0)
In cell B2 =Datedif($a$1,a2,d)'get days diff
in cellC2 =A2-$A$1'gets HH:MM:SS but hours is total
in cell D2 = (A2-$A$1)-int(a2-$a$1)'gets the hours minutes seconds
in cell E2
Not sure what happened to the post?? Just saw it on lists, and all the quotes
where somehow removed?
In the B2 line the d is suppose to be in double quotes?
Here I took the info, and removed the comments, and changed the quotes to
~ characters. It also removed the spaces??
Did a test with
11 matches
Mail list logo
