Posted to microsoft.public.excel.programming

external usenet poster

Posts: 30

Adding Time to a variable in Excel VBA

I have a time string:
mytime= Format(Now(), "hh:mm:ss AMPM")
I need to add "00:00:40" to mytime
How can I do so and avoid mismatching.

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
Run-Time error '91': Object variable of With block variable not set	jammin1911	Excel Programming	3	June 6th 06 06:36 PM
Run-time Error'91: Object variable or With block variable not set	DynamiteSkippy	Excel Programming	4	September 26th 05 07:47 AM
Adding time in Excel	MovieSchedules	Excel Worksheet Functions	1	January 31st 05 10:18 AM
Run-time error '91': "Object variable or With block variable not set	Mike[_92_]	Excel Programming	2	December 30th 04 10:59 AM
Adding time in Excel	tahirab	Excel Worksheet Functions	1	November 10th 04 09:47 PM

All times are GMT +1. The time now is 10:32 AM.

About Us

"It's about Microsoft Excel"