|
|
convert time to 1/4 hours by
lktx
I have created a spreadsheet for keeping track of work hours. I have a
calculation already for hours worked but need to be able to convert 7:45 to
7.75,...
|
February 15th, 2010 05:14 PM
by lktx
|
2 |
105 |
|
|
|
February 15th, 2010 05:13 PM
by T. Valko
|
5 |
94 |
|
|
|
|
1 |
101 |
|
|
Problem in calculating the outcome by
Elton Law[_2_]
Dear Expert,
I have problem in doing a task.
Say below ...
A1 is name. B1 to Z1 is comprised of 25 names ...
A2 is Shifts. There are 12 Shifts in a week. ...
|
February 15th, 2010 04:46 PM
by PJ
|
6 |
137 |
|
|
UDF's via Automation Addin in Excel 2010? by
Ralf Steinstraesser
Hi,
does anybody know about the compatibility of Excel 2010 with User Defined
Functions via the Automation addin model. We had developed a plugin, which
was...
|
|
1 |
290 |
|
|
|
|
1 |
118 |
|
|
|
February 15th, 2010 03:19 PM
by aprendiz
|
0 |
90 |
|
|
Matching names and inserting spaces by
ILunacy
I hope someone can help me out with this. Say I have column A filled with
like 500 names, and column B filled with 300 of the same names. Is there a
way or a...
|
February 15th, 2010 03:17 PM
by ILunacy
|
3 |
149 |
|
|
Workday function question by
Spike
I am slightly confused with the Workday function and would appreciate advice.
If I have paid someone to work 21 days (Monday to Fridays, weekends
(Saturday...
|
February 15th, 2010 02:52 PM
by Mike H
|
2 |
115 |
|
|
Times by
Sandy
I have a drop down list in C5 and D5 with times ranging from 12.00 AM to
11.45 PM.
I have the following formula in E5 which works well to calculate hours...
|
February 15th, 2010 02:15 PM
by JLatham
|
2 |
109 |
|
|
|
|
1 |
166 |
|
|
Auto Short by
Fareez
Dear Friends
I want a function which should auto short the numbers or letter
EX:
1
2
4
if i enter now 3 it should go above 4 automatically (I am not expert in...
|
|
2 |
118 |
|
|
Matching data by
Trish Smith
Hi everyone,
I get database outputs in the form of CSV tables.
There are 3 tables Location , Learner and Result.
MS Query is used to match up the data from...
|
|
0 |
80 |
|
|
Array addressing question... I think by
John Bennett[_2_]
Hi,
I have a problem I can't seem to solve.
Columns B through G contain data.
Row 4 contains a name.
Other rows contain numerical data.
I'm trying to figure...
|
|
1 |
112 |
|
|
1st Wed, 1st Sat, 1st Sun by
Keyrookie[_52_]
Hey all,
I received this formula on this forum to always show the 1st Wed. of a
month:
=TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())-3)
What I now...
|
February 15th, 2010 08:58 AM
by Stefi
|
5 |
120 |
|
|
Weird VBA Behaviour by
msnyc07
Again, I'll apologize as not a coder, I am fixing code I was provided. I
checked and checked and determined somehow that the VBA is WORKING as are my...
( 1 2)
|
|
13 |
230 |
|
|
help in formula by
Junaid[_2_]
I have given a formula that gives the specific cell data into the text i.e
="text "&AB4&" text" now my problem is that AB4 is the percentage it gives
me 7 or...
|
|
1 |
78 |
|
|
Sum of cell which use if array function by
Pran
Hi,
I have many cells using if function which result is number.
I'd like to sum all of those cells, unfortunatelly i cant do that, the
result is none.
How...
|
February 15th, 2010 03:41 AM
by T. Valko
|
1 |
118 |
|
|
Lookup function by
marvin
I have excel 2003. I did a vlookup for my transcripts page. In the first
vlookup i needed it to look for the letter grade and give me the gradepoint...
|
|
1 |
82 |
|
|
|
|
2 |
102 |