All Questions
16
questions with no upvoted or accepted answers
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?
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 ...
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 ...
0
votes
1
answer
1k
views
SUMIF all times between a start and end time of each day
I have an interesting one which I am really struggling to resolve and feel this should be possible using SUMIFS somehow!
I have the following (as per the image):
I have a number of tasks to complete ...
0
votes
1
answer
1k
views
Removing date from datetime (VBA Excel)
I need to delete the date from mulitple rows with a datetime value. Or extract the time to another cell.
For example:
A1 = 3/11/2022 10:20:00
A1 after macro = 10:20:00
or
A1 = 3/11/2022 10:20:00
A2 = ...
0
votes
2
answers
814
views
=DATE() won't increment DAY when I try to drag or fill the other cells
I'm working on an excel file to track attendance. The excel sheet should have the flexibility of dynamically changing the year of dates. The user can enter the current year in a cell and it should ...
0
votes
1
answer
197
views
Excel Formula for auto date/time subtraction
I want to do the following in cell K14: If cell D14 contains C17, take cell F14 and subtract 3 hours and 45 minutes.
The date/time format I am using is a Julian Date/military time, so 16271/1845 ...
0
votes
1
answer
84
views
General questions about entering minutes into an Excel worksheet
I'd like to be able to enter minutes into Excel cells and have another cell that totals the minutes. I have no problem converting minutes into hours. However, when I enter information, I don't want ...
0
votes
1
answer
691
views
Subtract certain hours from a time in Excel
I want to know the time when 12 hrs and 30 mins is subtracted from a time let us say 10:00 AM(it should display 9:30 PM). But since Excel, by default, stores this date as 1st Jan 1990, I am getting a ...
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 ...
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 ...
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
884
views
Dynamic time in Excel spreadsheet column
I am trying to automate time in Excel. I have two columns that show time advancing in minutes and seconds. I want to be able to automate so that if the time changes in one row, it will automatically ...
0
votes
2
answers
2k
views
Converting a travel time to an Excel time
I have calculated the time it takes to travel from point A to point B. The results are in number of seconds. I have converted the number of seconds to Hours, Minutes, and Seconds in three cells. I ...
-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 ...