List Info

Thread: Time Difference Display format




Time Difference Display format
user name
2006-06-28 18:09:04
Is there a way to subtract two time values and have the
result displayed
as d h:mm:ss where the hours will be less than 24 and the d
represents
the number of days in the difference.  

Example: 1/9/05 2:57:08 - 9/23/04 14:41:34 would display as
107 12:15:34
instead of 1280:15:34 

Paul J Koch

-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
On Behalf Of Lemmons, Wyatt
Sent: Wednesday, June 28, 2006 10:47 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Re: (but I'm not going to be here Friday!)
Oxymoronlike

Those are always good Bob !!!

Number 5:

whack

v. According to arch-hacker James Gosling (designer of NeWS,
GOSMACS and
Java), to "...modify a program with no idea whatsoever
how it works."
(See whacker.) It is actually possible to do this in
nontrivial
circumstances if the change is small and well-defined and
you are very
good at glarking things from context. As a trivial example,
it is
relatively easy to change all `stderr' writes to `stdout'
writes in a
piece of C filter code which remains otherwise mysterious.

whacker

n. [University of Maryland: from hacker] 1. A person,
similar to a
hacker, who enjoys exploring the details of programmable
systems and how
to stretch their capabilities. Whereas a hacker tends to
produce great
hacks, a whacker only ends up whacking the system or program
in
question. Whackers are often quite egotistical and eager to
claim wizard
status, regardless of the views of their peers. 2. A person
who is good
at programming quickly, though rather poorly and ineptly. 

SO,   It seems this whacker is whacking as we speak ....  (
sorry )

Feeling especially whacky right now  

thank you,
Wyatt Lemmons, HSG
(425) 830-5962  4x10 Wrk Sch ( Fri OFF ) & Telecommute:
Wed

-----Original Message-----
From: Umlas, Robert [mailto:rumlasKPMG.COM]
Sent: Wednesday, June 28, 2006 10:36 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: OT: (but I'm not going to be here Friday!)
Oxymoronlike

1. Is it good if a vacuum really sucks? 
		
		2. Why is the third hand on the watch called the second
hand? 
		
		3. If a word is misspelled in the dictionary, how would
we ever know? 
		
		4. If Webster wrote the first dictionary, where did he
find the words? 
		
		5. Why do we say something is out of whack? What is a
whack? 
		
		6. Why does "slow down" and "slow
up" mean the same
thing? 
		
		7. Why does "fat chance" and "slim
chance" mean the same
thing? 
		
		8. Why do "tug" boats push their barges? 
		
		9. Why do we sing "Take me out to the ball
game" when we
are already there? 
		
		10. Why are they called "stands" when they are
made for
sitting? 
		
		11. Why is it called "after dark" when it
really is
"after light"? 
		
		12. Doesn't "expecting the unexpected" make
the
unexpected expected? 
		
		13. Why are a "wise man" and a "wise
guy" opposites? 
		
		14. Why do "overlook" and
"oversee" mean opposite
things? 
		
		15. Why is "phonics" not spelled the way it
sounds? 
		
		16. If work is so terrific, why do they have to pay you
to do it? 
		
		17. If all the world is a stage, where is the audience
sitting? 
		
		18. If love is blind, why is lingerie so popular? 
		
		19. If you are cross-eyed and have dyslexia, can you
read all right? 
		
		20. Why is bra singular and panties plural? 
		
		21. Why do you press harder on the buttons of a remote
control when you know the batteries are dead? 
		
		22. Why do we put suits in garment bags and garments in
a suitcase? 
		
		23. How come abbreviated is such a long word? 
		
		24. Why do we wash bath towels? Aren't we clean when we
use them? 
		
		25. Why doesn't glue stick to the inside of the bottle? 
		
		26. Why do they call it a TV set when you only have one?

		
		27. Christmas, what other time of the year do you sit in
front of a dead tree, and eat candy out of your socks?
 
 *** ANY TAX ADVICE IN THIS COMMUNICATION IS NOT INTENDED OR
WRITTEN BY
KPMG TO BE USED, AND CANNOT BE USED, BY A CLIENT OR ANY
OTHER PERSON OR
ENTITY FOR THE PURPOSE OF (i) AVOIDING PENALTIES THAT MAY BE
IMPOSED ON
ANY TAXPAYER OR (ii) PROMOTING, MARKETING OR RECOMMENDING TO
ANOTHER
PARTY ANY MATTERS ADDRESSED HEREIN. ***
 
Any advice in this communication is limited to the
conclusions
specifically set forth herein and is based on the
completeness and
accuracy of the stated facts, assumptions and/or
representations
included. In rendering our advice, we may consider tax
authorities that
are subject to change, retroactively and/or prospectively,
and any such
changes could affect the validity of our advice. We will not
update our
advice for subsequent changes or modifications to the law
and
regulations, or to the judicial and administrative
interpretations
thereof.



************************************************************
************
*****
The information in this email is confidential and may be
legally
privileged.  It is intended solely for the addressee. Access
to this
email by anyone else is unauthorized. 

If you are not the intended recipient, any disclosure,
copying,
distribution or any action taken or omitted to be taken in
reliance on
it, is prohibited and may be unlawful. When addressed to our
clients any
opinions or advice contained in this email are subject to
the terms and
conditions expressed in the governing KPMG client engagement
letter.  
************************************************************
************
*****



------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )