Posts by jeffmangum_nmh

Re: Macro insists on "break" mode; it always "steps in" and will not run normally

Oh I've been there. It's really annoying.

Have you tried compiling the project? Debug->Compile Project

Re: Calculating Period Between Time Interval

Hello. Maybe this will get you started.

I would concatenate the three columns
=CONCATENATE(A2,"-",B2,"-",C2)

And then using the Days360 function to get how many days have passed.

If I understood your problem, that should do it.

Cheers!

Re: write a formula referencing a cell with another formula in excel

Hello.

I don't know the context of what you're trying to do, but you might be right.

The formula in AK2 results in a text value, not a number value. That's why you might want to change it.

As I said before, I don't know the context of your work, but if you use =INT(IFERROR((AH2-AI2-AJ2)&"","")) you will get a numeric value (in this case, an integer).

Let me know if this works.

Cheers!