Explore Spreadsheets on Experts Exchange

Expert Solutions for Your Tech Problems

Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed...

Read more
  • 7.0K Content
  • 2.0K Contributors

Expert Spotlight
Consultant

Always working for better, faster and cheaper solutions!

Troubleshooting Solution

Extract Time from racedatetime

9
Hi,
I would like a formula to extract time from the data in attached sheet
Than Time Extract.xlsxks
Ian
Article

Excel - Did You Know !

byShums
10
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to do.
Video
Courses
Post

Oy... You ever make some changes to the underlying data …

7
Oy... You ever make some changes to the underlying data columns in a spreadsheet and then not …
Troubleshooting Solution

Convert date and time format

7
Hi,
Can someone please assist with two formulas to convert date and time from a cell with combined …
Troubleshooting Solution

Add rounding to two decimal places in spreadsheet

5
How do I add rounding to two decimal places after this formula? =(E5-D5)*24&" hrs"?
Troubleshooting Solution

Use keywords to indent nested structures in Excel

96
Attached is an example Excel spreadsheet with syntax similar to a table in a 60 page word doc. It …
Troubleshooting Solution

Calculate time in each country to reflect noon Central Time

12
I need to calculate the time that it would be in each country when it is 12 noon my time.

This page …
Troubleshooting Solution

Values in Excel Spreadsheet Change When Clicking "Enable Editing"

5
Received a rather extensive Excel spreadsheet from a client via email.

When we open the spreadsheet …
Troubleshooting Solution

Sort two ranges without blank rows

43
Hi
I wanted to sort data without missing rows
I have enclosed a sheet with explanations.
Most …
Troubleshooting Solution

Time elapsed in a spreadsheet

9
I want to retain the a/m pm format but still do time calculations in the editable column F of this …
Troubleshooting Solution

Replacing text in a formula with a variable

9
Hello,

I think this is very rudimentary but I'm haven't a moment. :(

I am building an Excel …
Troubleshooting Solution

How do I do a vlookup using data from a another spreadsheet.

8
In short I need to update data on the Master sheet with the new data on the new data sheet. Using a …
Troubleshooting Solution

Search multi-criteria in VBA Excel

9
Is there a better way to match a multi-criteria for a cell simliar ot the code below in Excel ?

Thx

If …
Troubleshooting Solution

Change location for an addin location

5
Hi,
How do I change the directory in the add ins page.
Currently it show the program in D:\ directory. …
Video
Troubleshooting Solution

Unable to create specified active x control

13
Can someone please help with this error message. I sent an Excel file to a friend and he cannot open …
Troubleshooting Solution

Losing command button name and events when copying between spreadsheets

18
The problem:

I have an active worksheet that is the result of an import of a CSV file. The …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more