All Questions
101
questions
1
vote
1
answer
199
views
Date range for jobs & conversions SUMPRODUCT
I'm trying to run a report within Excel that shows the total number of jobs completed by employees within a date range and also a count of the number of conversions per employee within the same date ...
3
votes
1
answer
2k
views
Excel 2010: Daylight Savings - calculate # of hours between timestamps for any given day
I have a checksheet which cross-checks various water measurement points, reading the average rates from around thirty different meters out of another system. I've automated this checksheet so a VBA ...
-1
votes
1
answer
136
views
Excel lookup table based on time
I need to set up a way that I can tell which shift certain things happen in. I have a table that has all the times, but I would like to attach each time to a shift (i.e. if this happens between 14:00 ...
1
vote
0
answers
364
views
EXCEL 2011 - Inventory with Matrix and Vlookup
I am creating an inventory matrix, which has on the first column a list of all the items in the inventory, and on the first row a list of the dates for when the inventory gets renewed. Basically, not ...
1
vote
2
answers
1k
views
DATEVALUE() gives different values for similar data
In one column, I have timestamps in the format Jun 10, 2015 11:36:51 AM
So, to get the date from that column, I created another column and used the formula
=DATEVALUE(CONCATENATE(MID(D2,5,2)," ",...
0
votes
2
answers
173
views
Get average of time data
How do I compute average time in my column N?
My AHT works when I only use =AVERAGE(N6:N7), but when it is =AVERAGE(N6:N755), it doesn't work.
Note that there are only values in N6 and N7, values in ...
1
vote
3
answers
17k
views
How to convert text to date in MM-YYYY format
I have a column in Excel with the following entries in text format:
7.2013
7.2014
8.2013
8.2014
9.2013
9.2014
10.2013
10.2014
11.2013
11.2014
12.2013
12.2014
1.2015
How can I convert this ...
0
votes
0
answers
1k
views
Excel formula returning different results on different machines
For a piece of work I'm doing, I use a formula that calculates the difference between two dates for each row in the report that the system generates. Essentially, the software I'm using generates the ...
2
votes
1
answer
45k
views
Formula to update cell based on user changing another cell's content
I want to know if there is a formula to update a cell in Excel with today's date
when a user changes any value in the row that contains that cell
OR
when a user changes the value of 6 / 7 / 8 ...
0
votes
3
answers
1k
views
How do I get the fiscal year to start on a specific date each year in Excel?
I used the formula listed here to generate a fiscal year based on the current month. I have an odd requirement where she wants the fiscal year to start on 6/20. For example, any dates ranging from 6/...
0
votes
1
answer
885
views
Calculate the difference in hours from now and next workday's 9am
How do I calculate the difference in hours from now and the next workday's 9am?
If NOW() is Thursday 6pm and the next workday is Friday, the function would then return 15.
If NOW() is Friday 5pm and ...
0
votes
5
answers
21k
views
Excel VBA or Formula to convert text to Date with Time type
I have a quite a number of data where its date/timestamp has been imported into excel as text. Excel does not really recognize it as date with time. e.g. 25.08.2011 16:17:59 (mm.dd.yyyy hh:mm:ss)
...
5
votes
3
answers
22k
views
Subtracting TIME UNITS (not time of day)
How do I subtract TIME UNIT (not time of day)? Last year I ran a marathon in 48 minutes and 20 seconds. This year I ran a marathon in 47 minutes and 50 seconds. When I do this in Excel, I tried ...
1
vote
3
answers
1k
views
Excel date & time formula-round up cell value
I'm preparing a report of usage statistics for a group study room reservation system we use at the library where I work. I've exported all the reservations from MySQL in Excel for the past year and am ...
-1
votes
3
answers
6k
views
Formula to match dates in Excel
This may sound really simple but I need a formula that checks if one column's date is the same as another, and if so put 'true' or '1' or something. I tried =IF(H2=G2, "True", "False") but it does not ...