Posted to microsoft.public.excel.programming

external usenet poster

Posts: 4

Here's an Easy One

I have the following two variables:

dim myVar as single
dim myDate as date

myVar ends up with a value of 0.96.
myDate ends up with a value of "9/29/06 12:33".

How do I add myVar to myDate to get "9/30/06 11:37"?

I've tried running every conversion function on myVar I can think of and
I'm still getting a type mismatch.

-Kevin

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
Easy one... but not for me :S	ChrisMattock	Excel Worksheet Functions	7	July 3rd 06 09:49 PM
probably easy but....	obion	Excel Worksheet Functions	3	October 7th 05 07:08 PM
Probably easy but I need help!	djbob2k2	Excel Worksheet Functions	1	September 19th 05 01:44 AM
new user with easy question? not easy for me	speakeztruth	New Users to Excel	5	June 3rd 05 09:40 PM
Easy but not for me!!	Lynda	Excel Programming	3	February 16th 05 08:48 PM

All times are GMT +1. The time now is 10:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us