|
|
using the MOD funktion in excel 2003 by
a2apple
start time
11:00:00 PM (A3)
end time
3:00:00 AM (B3)
i am trying to use mod to work out the number of hours that a person worked using excel
so i used the...
|
|
6 |
184 |
|
|
|
|
6 |
510 |
|
|
Paste Value Macro by
AA
Here's a macro that works fine for me. It converts a formula in the
cell where the cursor is to a value, or formulas in selected cells to
values:
Sub...
|
May 17th, 2004 10:50 PM
by AA
|
7 |
501 |
|
|
|
|
11 |
198 |
|
|
conditional formulas by
Aaargh
I've done all the searches online and off for help. Now time's running out
for my project. Here's the situation...
My data is in two columns with thousands...
|
May 19th, 2007 12:25 AM
by JMB
|
2 |
83 |
|
|
Reformatting by
aagawu
I've inputed data across about 60 worksheets, and now I want to combine certain areas from each worksheet into a different worksheet. Is there anyway to do...
|
|
1 |
127 |
|
|
|
|
5 |
209 |
|
|
|
December 30th, 2008 06:18 AM
by aamir
|
0 |
100 |
|
|
|
January 15th, 2009 02:29 PM
by John
|
1 |
126 |
|
|
margins and page size in worksheet by
Aamir
I will try to express myself clearly but I might not be able to fully do so:
I have a 22 page worksheet with each page as a technical data sheet.
When i print...
|
October 11th, 2006 01:50 AM
by Pete_UK
|
1 |
79 |
|
|
|
August 23rd, 2006 06:28 AM
by Epinn
|
3 |
114 |
|
|
excel worksheets by
Aamir
i have three questions:
1. sometimes a sheet or an area outside the sheet becomes grayish in color.
what does this mean and how does it hamper my work?
2. what...
|
April 16th, 2006 05:36 PM
by Aamir
|
2 |
115 |
|
|
|
|
2 |
77 |
|
|
Unable to change security in Excel 2007 by
Aare
I have a model in Excel 2003 with macros that I have converted to Excel 2007
*.xlsm. I have set the security to "enable all macros." However, when I load...
|
|
1 |
88 |
|
|
|
|
1 |
159 |
|
|
|
December 22nd, 2005 01:46 PM
by Aaron
|
2 |
207 |
|
|
Excel format conversion by
Aaron H
Hi guys, is there a way to convert the following
123456789 to 123-456-789
or
abcdefghi to abc-def-ghi
I need to convert a long list of serial numbers so I can...
|
|
9 |
922 |
|
|
|
|
3 |
103 |
|
|
|
|
6 |
146 |
|
|
|
|
4 |
286 |