All Questions
101
questions
3
votes
1
answer
12k
views
Excel - Convert dates and currency as text to Excel dates and numbers respectively
I frequently copy and paste HTML tables into Excel to do quick aggregate operations (e.g. sums, averages, etc).
In this example, PayPal, their HTML table contains text values like
A | B ...
0
votes
2
answers
1k
views
Excel VBA Right Function Error
I'm trying to automatically update the date range on the top of my report in Excel based on the date range from data I download from a text database. In the below listed macro I get a Run-time error '...
1
vote
1
answer
6k
views
Avg times in mm:ss.0 format
I have a range of times formatted as mm:ss.0. The problem is trying to average these times.
Time AVG
2:44.35
2:42.88
2:47.49
2:48.86
2:56.31 00:00.0
0
votes
1
answer
793
views
I neet to convert date value into date/time value in a cell
I have a cell with 07/26/13 and I want a formula to take this date each day it is updated and convert it to 07/26/13 00:00, so that I can make a formula in another cell with a time reference of IF ...
0
votes
2
answers
3k
views
How to convert unit of time to Centiseconds in Excel?
I am working with Excel and I need to convert a time unit like this mm:ss.00 (centiseconds) all to centiseconds.
There are some formulas to extract Minutes and Seconds from this format but I dont ...
1
vote
3
answers
9k
views
How to extract the time HH: MM of a cell stored as "dd/mm/yyyy hh:mm format in Excel?
I.E. 01/07/2011 09:30 I would like to extract 09:30 of this cell.
How I can do it
0
votes
2
answers
10k
views
Calculating Time Difference in hh:mm:ss format
I have time format of hh:mm:ss in one cell and the same formatted time in other cell .
I calculate the difference of these two cell and get hh:mm:00 as my difference.
What I request if someone can ...
3
votes
2
answers
2k
views
Is this the best strategy for displaying a negative time value in Excel?
I am trying to send up a calculated cell as duedate - now() in order to quantify overdue vs. time remaining (negative values = overdue, positive values = time remaining). Consider:
Col A ...
0
votes
1
answer
412
views
Excel date formatting after formula calculation
Say I have the following two dates in column 1 of my spreadsheet:
Tuesday, February 12, 2013 10:13 AM
2/12/2013 10:13
When I highlight the column and change the cell formatting to a date type of "3/...
1
vote
3
answers
60k
views
Calculating time in Excel between AM and PM
I have an Excel spreadsheet that calculates the difference between two times. The formula that I'm using, for example, is as follows:
Cell A1 12:00 PM
Cell B1 12:30 PM
Cell C1 =minute(B1-A1) and the ...
0
votes
1
answer
304
views
monthly totals comparing two date columns, Excel 2010
How can I calculate a monthly total of the courses completed for the month ONLY when they were due for that same month (sometimes students are late and sometimes early)?
The spreadsheet has a column ...
0
votes
1
answer
2k
views
Populate a list of Sunday's dates and ignore the Sundays in an exception list in Excel
I'm working on a sheet which I have to populate with Sunday dates, and make sure that dates from an exception list aren't present in my final list
Goal: to have the list of dates of only working ...
2
votes
2
answers
37k
views
Calculating a duration in excel from date and time
I have 2 columns in excel, each column includes a date and a time in the following format: 'dd/mm/yyyy hh:mm'. One is a start date/time, the other is an end date/time. The end date/time could be ...
2
votes
1
answer
242
views
Conditional Static Time Entry in Excel
I need to insert a STATIC time into excel based on a condition in a cell. i.e. Cell A1 = "A" then insert the static time. Any ideas?
0
votes
3
answers
10k
views
How autofill all rows between two dates in excel with the second date as the incrementing limit?
I am trying to figure out take one cell.... say A1 and put a date in it.... then move down several thousand rows and give another date 3 months later... and have it auto fill the dates between the two....