Hey Steve,
Does one of these help?
=INT((B1-A1)*24)Total hours between two times (4)
=(B1-A1)*1440 Total minutes between two times (295)
=(B1-A1)*86400 Total seconds between two times (17700)
=HOUR(B1-A1)The difference in the hours unit between two times. This
value cannot exceed 2
ll,
>
> I think in my attachment u will get your solution.
>
> Thanks & Regards,
> Gaurav Jain
>
>
>
>
>
> On Fri, Apr 16, 2010 at 10:33 AM, Vikas Chouhan wrote:
> > hi just chk
>
> > On Thu, Apr 15, 2010 at 12:51 AM, MD18358 wrote:
>
>
Hi All:
I don't want the "number of Permutations" I want to see the
permutations to a calculated sum.
For example: How many different ways can I get 20 by looking at the
number 1 through 19.
My answer should look like:
1+19
2+18
3+17
4+16
...etc
Any ideas???
As always, Thanks
Michael
--
---
Hi Chaudhry,
I hate to commit sacrilege in the Excel VBA sight but its sounds like
excel is probably not the right solution for such a massive task.
Access can handle larger database queries. Even if you use Access to
perform all your summerizing and then export it back to excel for the
presentati
Gaurav,
There is a great website called http://dashboardspy.com/. Check it
out! it gives lots of useful information to bring you up to speed on
building dashboards.
You should note in most cases, when it comes to dashboard, the simpler
it looks, the more difficult it is to build.
Good luck
Mich
Hi Paul:
Thanks for this and happy holidays which ever one or two you do this
time of year! I Think I'll try a combination of your #1 and still use
volumes of acohol because there would be no fun it for me, otherwise.
regards,
Michael
On Dec 23, 4:04 pm, Paul Schreiner wrote:
> For this, I ha
I have a combo box pulling a list that is day/month/Year, however when
the text in the combo is pushed back onto the spread sheet the dates
are month/day/year. How can I make the listing consistant?
Mayby there is an example someone has that I can see the code.
Thanks
Michael
Sorry, if this was
Hi All!!!
Does anyone have any good examples of how I can use the MYEXTRACT
function as part of a macro and not just as a function?
I'm trying to extract a word or phrase found somewhere in column A
with a string found in column somwhere in column "B". In my true use
of the function, I have 12,0
Hi All:
First off this is a terrific user group and is required reading for my
team!
Here is my question:
I receive a table that has the headers
A1: Name
B1: Address1
C1: State
D1: Zip
The next time, I receive the table with headers may say:
A1: Name
B1: Address1
C1: Address2
D1: State
E1: Zip
