Totaling using two sets of data
I am trying to count and get the total of 2 sets of data: one set includes dates, the other includes words. The dates all include month, day, and years, but the data I would like to use in my results would just consist of the years. I'm working with semi trailer repairs, so the formula I would like to use should be saying "count all issues only if year"...like "count all tire repairs only if 2016". I have been googling and looking around, but all I can find on the subject is to get a result of true or false, but I want a number as my result. so far, I have this: =COUNTIF(issues,"axles")+COUNTIFS(dates,">="&DATE(2016,1,1),dates,"<="&DATE(2016,12,31) I named one column "issues" and another column "dates." ("axles" is one of the issues I'm trying to total.) I know this formula is valid, but it adds the totals of the "issues" column and the "dates" column separately instead of taking both into account in the total, if that makes sense. Hopefully someone can help!
Trouble quoting date+time(hour/mins) of project start date/completion using the WORKDAY function.
Hello, I'm currently tasked with completing an excel document that accurately quotes job start and completion dates (including time of day within a work shift). So far I've been able to come up with a system that works for the most part but I'm having some issues relating to the WORKDAY function. My goal is to have an input start date/time (ex. Wednesday July 10, 2019 7:00 AM) which in turn will generate accurate information of the completion date/time for the job and simultaneously calculating when the next job will start/finish (start date/time is the finish date/time of the previous job). Ex: Start: Wednesday July 10, 2019 7:00 AM - Finish: Thursday July 11, 2019 2:55 PM. Start: Thursday July 11, 2019 2:55 PM - Finish: Friday July 12, 2019 9:45 AM. So far I've been able to calculate the finish "date" but I'm having troubles with the information generating the "time" of completion and therefore the next jobs start date/time (specifically time) correctly. The system seems to be generating the "day of completion" fine but the "hours/mins" are not calculated into the equation. I would like the WORKDAY function to be set to 7:00am - 3:30pm but I'm not sure if this is possible. The document is referring to a chart which calculates the approximate time it takes to complete a specific job depending on the amount of "parts"and "blades". (ex: (#of parts * #of blades) * Time Per Blade = Total time (0.0 days) .) The total time is then used in the workday calculation: WORKDAY(start_date, Total Time, no holidays). I'm not sure if I'm using the WORKDAY function incorrectly or not. The end goal is to have it calculate the date and time of day when a job will be competed, then in turn generating the next jobs start time. Attached is the document for better clarity. Any help would be appreciated. I'm fairly new to excel so spare me the criticism if this is a common error. Thanks!
