Posted to microsoft.public.excel.programming

Rick[_19_] Rick[_19_] is offline

external usenet poster

Posts: 52

elapsed time in msgbox

The only thing that confuses me now is that in the worksheet, I got "0 years, 6 months, 19 days,
12 hours, 7 minutes, 57 seconds" as a result. Only a few seconds later in the immediate window with the solution above, I got 00 years, 7 months, 20 days, 12 hours, 55 minutes, 48 seconds. The equation is the same in both...

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
time elapsed	tomas	Excel Discussion (Misc queries)	0	December 11th 08 04:00 PM
Calculate Ending time using Start Time and Elapsed Time	Chief 711	Excel Worksheet Functions	5	May 13th 08 04:34 PM
Need Elapsed Time Help	Jwy	Excel Worksheet Functions	2	September 29th 05 03:54 AM
elapsed time	Sweetpea60	Excel Worksheet Functions	6	March 2nd 05 04:41 PM
Elapsed Time	Random	Excel Programming	4	September 5th 03 01:18 PM

All times are GMT +1. The time now is 05:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us