|
|
Adding times together by
[email protected]
Hi
I need to add times together, i.e. 6:30, 5:30, 5:00 etc to get and answer of
17 hours
Can someone help me with the formula please.
Thanks
Yvonne
|
January 16th, 2005 10:19 PM
by Max
|
2 |
172 |
|
|
hex to decimal convert by
Nadia
Hi
Is it possible to have a formula convert a string of hex values to decimal
numbers?
say put hex values, in column A1- A8
and as soon as you put in values in...
|
|
4 |
209 |
|
|
VLOOKUP by
Lori
I can't remember how to use VLookup! I have to worksheets with columns of
common data I need to "merge" the two without duplicates. Can someone tell me
how to...
|
|
3 |
201 |
|
|
2003 update link when Source open by
Ausrobbo
I have a similar problem. We have a procedure which opens a (multiple sheet)
Excel workbook, then open a Word document with links to the workbook. We
rename...
|
|
0 |
457 |
|
|
Lookup List to Index by
SSR
Hello,
I have a sheet with 2 columns as Below
A B
1 Apples 1
2 Oranges 3
3 Bannanas 2
Cells in Column A have data...
|
|
2 |
200 |
|
|
|
|
2 |
229 |
|
|
|
|
46 |
2,621 |
|
|
Alternative window size? by
Hans Näslund
I would like to save one of my worksbooks as a full-screeen window, without
affecting other workbooks or the standard template.
How do I do? Is it at all...
|
|
0 |
313 |
|
|
|
January 17th, 2005 05:07 PM
by plato
|
0 |
387 |
|
|
self-building dropdown list by
boris
would like to have a sheet where one of the columns has
cells which are a self-building list. I understand the
need to have any formula or validation copied...
|
January 17th, 2005 05:33 PM
by Max
|
1 |
268 |
|
|
Hiding columns based on user/password by
jmatchus
Is there a way to hide columns based on the password entered? I am trying to
go from a Paradox table to Excel and in Paradox there was the capability to
hide...
|
|
0 |
130 |
|
|
|
|
2 |
126 |
|
|
|
|
1 |
339 |
|
|
lookup misses the first entry in table by
Spunky
If I insert a row with a number less than 074 first, the 074 does as I expect
on my spreadsheet. However, if I have it as is below, any lookup to 074
returns...
|
January 17th, 2005 08:29 PM
by LanceB
|
1 |
145 |
|
|
|
January 17th, 2005 08:35 PM
by LanceB
|
1 |
120 |
|
|
|
|
1 |
541 |
|
|
|
|
1 |
450 |
|
|
Insert value of a cell as a filename by
Ralph Howarth
Is there a way to insert the value of a cell as a filename for referencing a
cell in another workbook?
ex: =FileName!$Col&Row
where FileName is a...
|
|
0 |
322 |
|
|
|
January 18th, 2005 12:21 AM
by Ola
|
1 |
163 |
|
|
|
January 18th, 2005 12:59 AM
by Ron
|
0 |
303 |