|
|
5 minutes intervals by
april
I have a column that is sorted by time & date in one min. intervals. I need
it to show me the time in 5 min. intervals. Obviously excel can do this I
just...
|
October 24th, 2006 12:32 AM
by Pete_UK
|
2 |
75 |
|
|
5 year service awards by
PAR
I need to use conditional formating to highlight 5 year incremental service
awards in a spreadsheet.
Column A has hire date, column b figures the years of...
|
March 22nd, 2006 04:11 PM
by PAR
|
0 |
110 |
|
|
50% formula by
wally
I have winxp 2003.
I have a sheet named data which has a list of names that looks like
this;
in cell a1 #1 Jackson - #2 Johnson
in cell a2 #3 Smith -...
|
August 11th, 2006 01:43 PM
by wally
|
2 |
128 |
|
|
5th Char in a cell by
enna49
Hi
I know this is simple, and I know I should know it, but I cannot get it to
work and I have searched Help and the answers seem more complicated than what...
|
February 9th, 2010 06:01 AM
by enna49
|
3 |
138 |
|
|
6 cell sum by
dc04wrightl
Hi,
I need a formula or a mathematic help. Basicaly i have 6 cells. I need to
tell it to be
0.1 when 1 cell if filled in
0.2 when 2 cells are filled in
0.3...
|
January 14th, 2008 07:08 PM
by RB[_3_]
|
2 |
116 |
|
|
6 Day working week (friday holiday) by
Dan Johns
Hieveryone,
I am an excell novice trying to put together a project calculation sheet. I need to calculate total days between 2 dates excluding each and every...
|
|
2 |
170 |
|
|
6 day/week function ie:networkday by
Robert
i am trying to calculate how many days between 2 dates that excludes
holidays, but includes saturdays. Networkdays is only for 5 day work
weeks...i need it...
|
|
6 |
107 |
|
|
6 months of working days by
Jennifer
Hi,
I'm trying to figure out how to calculate what 6 months of working days
would be. I've tried the various Networkdays formating, perhaps I'm using
the...
|
October 20th, 2005 04:36 PM
by KeLee
|
2 |
102 |
|
|
6 or more conditional formatting by
Conditional Formatting
Please give me sample of macro with 6 or more conditional formatting using
the drop down boxes
for example
apple cell turns to red
banana cell turns to ...
|
|
2 |
82 |
|
|
6.00 to this 0600 please by
Steved
Hello from Steved
I have 2 columns one with
=INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5"",0)) and the second with
=(D2+12)*100
Please can i combine the...
|
June 13th, 2005 04:22 AM
by Steved
|
2 |
84 |
|
|
60% formula by
wally
I have a bowling league with 16 teams; each team has its own
statistical sheet named 1 thru 16. Each week I manually compare the
team averages of the teams...
|
August 9th, 2006 11:53 AM
by wally
|
2 |
66 |
|
|
61 Hosting Web www.ivys.es by
tesddalws
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web...
|
|
0 |
169 |
|
|
64k row limit by
Jim
I copied the macro and it works on text files, but will this work if you have
a .csv file or does it have to be text? What I have is an extra large .csv
file...
|
May 3rd, 2006 09:17 PM
by Jim
|
3 |
82 |
|
|
|
|
4 |
84 |
|
|
7 Day Pacing Formula Help by
bbal20
Okay. I'm posting this for a second time in hopes that I can get some help. I
am trying to right a formula that gives me a pacing number for the end of the...
|
|
4 |
165 |
|
|
7 day workweek timesheet - excluding lunch by
S in AZ
I thought I alreayd posted this but don't see it anywhere, so forgive me if
this is duplicated somewhere.
I am looking for a formula to calculate total hours...
|
September 8th, 2006 11:26 PM
by fryguy
|
3 |
107 |
|
|
7 Function rule by
helpme
Is there a way around the excel rule that you may only have 7 functions in
one formula, im trying to do an if statemet with like 15 IFs.....can this be
done
|
|
4 |
83 |
|
|
7 function rule cont. by
helpme
ok everyone asked for more details, so here they are...good luck and thanks
for helping. Specifically i have a two page workbook, on the first page is a...
|
|
1 |
82 |
|
|
7 previous days average by
Carlee
Hi All,
Question: What function can i use to create an average value of the
previous 7 days?
Column AJ contains data, which is added to everyday
Column B...
|
October 28th, 2007 10:02 PM
by MartinW
|
9 |
97 |
|
|
|
|
6 |
72 |