Not of Double Type but within Double Type Range?

**exceltabz** · 05-08-2014, 10:00 AM

Hi Everyone,

I am getting a Type Mismatch for this value 0.291666666666667 as Double I'm not sure anymore why because:

Double
Contains a double-precision, floating-point number in the range -1.79769313486232E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values.

The number I highlighted in blue should be within that range but why the Type Mismatch Error?

Thanks

**romperstomper** · 05-08-2014, 10:03 AM

What's the actual code that gives the error?

**MarvinP** · 05-08-2014, 10:04 AM

Hi,

Are you using this Double in a function that expects a TEXT string? Are you using this Double when the function is expecting a RANGE of cells instead of a number?

We really need to see the formula or a sample of the workbook to understand what you are seeing.

To attach a workbook, click on "Go Advanced" and then the Paper Clip Icon above the advanced message box.

**exceltabz** · 05-08-2014, 10:13 AM

im actually trying to look for values that are of time type only the column would only have either a string or time and since time is in decimal form in vba i did this

and also note that for any value less than 7:00 AM or 0.291666666666667, it does work... for example 5:00 AM, 5:30 AM...

for i = 1 to max_row
   possibletimevalue = range("A" & i).value
   if vartype(possibletimevalue) = 5 then
       converteddecimaltotime = convertdecimaltotime(cdbl(possibletimevalue))
   end if 
next

function convertdecimaltotime(atimeindecimal as double) as date
'code to convert decimal to time type
end function

**romperstomper** · 05-08-2014, 10:25 AM

Works OK here. Can you post a workbook where it fails?

**exceltabz** · 05-08-2014, 10:44 AM

Hi Gurus,

Thanks for taking the time and apologies for the misleading topic because I found what caused the error:

Here's my actual code for converting decimal to time

Function DecimalToTime(TimeInInt As Double) As Date
    Dim DTT As Double 'i forgot to declare my DTT variable, somehow not declaring this caused the Type Mismatch error
    DTT = TimeInInt * 24
    DecimalToTime = TimeValue(Int(DTT) & ":" & ((DTT - Int(DTT)) * 60))
End Function

I'll mark this now as resolved! Thanks again...

**shg** · 05-08-2014, 10:52 AM

Or

Function DecimalToTime(TimeInInt As Double) As Date
    DecimalToTime = CDate(TimeInInt)
End Function

**exceltabz** · 05-08-2014, 11:01 AM

Wow thanks, this makes thing a lot simplier!

Originally Posted by shg

Or

Function DecimalToTime(TimeInInt As Double) As Date
    DecimalToTime = CDate(TimeInInt)
End Function

**shg** · 05-09-2014, 09:30 AM

You're welcome.

Not of Double Type but within Double Type Range?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Not of Double Type but within Double Type Range?

Re: Not of Double Type but within Double Type Range?

Re: Not of Double Type but within Double Type Range?

Re: Not of Double Type but within Double Type Range?

Re: Not of Double Type but within Double Type Range?

Re: Not of Double Type but within Double Type Range?

Re: Not of Double Type but within Double Type Range?

Re: Not of Double Type but within Double Type Range?

Re: Not of Double Type but within Double Type Range?

Thread Information

Users Browsing this Thread

Similar Threads

Data type is changing from original type when double clicking the data in the pivot table?

Maths using Double type

convert textbox value from string to either single or double numeric data type

Comparing type double variables of different lengths

Type mismatch using rnge as Range with Type 8 Input Box

Bookmarks

Bookmarks

Posting Permissions