hour

Hi, I am new to excel, I want to know if I can add. See Below. Time is written in a specific cell, like this 10:30. I want to add 8:30 hour to it. Can I do it like this = A1 (cell in which time written ) + 8:30. Thanks in advance

So Im working on a sheet to measure performance in our warehouse. A1=226 cases per hour B1 = 74% (performance) In order for me to see what A1 would look like if B2 were 100% I make a formula like this "A1/B1" which equals 306 cases per hour. That's all fine and dandy, but what if i want to...

disregard pls..thx

Hello. I am looking for a formula to calculate how far you travel in ONE SECOND at both 40 KPH and 60 KPH. Yes Kilometers Per Hour. I am in Canada!!

Dear Excel Geniuses, I am trying to copy a cell every time it updates and put it in a new cell. I am working in a sheet with different numerical values that automatically update every hour. These values are a2:a101. I want to record their changed values to the right of the original number...

Hello. I'm looking for help in creating a production schedule in excel, Gantt chart style. The schedule is for Mon - Fri, 10 hour shifts. Id like the schedule to show in 1 column the routed time in units per hour to show how many units should be produced every hour, based on the total units...

I am trying to create a document for the VP’s of my companyto be able to type in a Region number and date and have it display only thosestores that have items sold that are under 35. I would also like to break it up buy hour. I have beentrying the formula...

<tbody> row/column C D E ---> BD ----> BI 11 Start End Target TimeHour Target 12 3:00 AM 6:00 AM 2 12:00 AM 1 13 1:00 AM 6:00 AM 4 1:00 AM 4 14 4:00 AM 6:00 AM 2 2:00 AM 3 15 4:00 AM 7:00 AM 3 3:00 AM 2 16 1:00 AM 5:00 AM 4 4:00 AM 2 17 9:00 PM 12:00 AM 5 5:00 AM 2 |...

Newb here so bear with me if the answer is obvious! Situation: Trying to convert field of half hour with that contain no ":" to full hours using military time. It's relatively easy for half hours that contain four characters. Hypothetical Example: =left(text,[num_char]) for "1000" returns...

<tbody> Total peons Per Peon income/h Peon loss/h Time calculated Totalgold Player1 10000 2.5 3% n ??? Player2 11000 2.5 3% n ??? Player3 </tbody> So, this is probably more a math problem than an excel problem. But while trying to simulate a game, I've come...

Hello all. My work is instituting an incentive plan to encourage overtime when needed. They decided on a point system where you earn points for each hour you work of overtime. Each hour of each day may be worth a different point. As an example: Working 6:00 PM - 7:00 PM on Tuesday would be 1...

Greetings Again, I created a table to show the time it would take to complete a task based on the number of installers I have shown; however, the logic is based on 1 installer. So if I send out 2 installers it still will calculate based on 1 installer. 1 installer - 1 hour install time...

I have a massive list of employees who worked more than ten hours in a single shift. A2 = John Smith B2 = 7/15/18 C2 = 11:57 AM D2 = 4:03 AM My problem is that we use ADP and in our system, you can clock in 7 minutes before or after the start of your shift and still get credit for starting at...

I am trying to figure out how to find the total trainers working in same hour, and needs to be able to change when a trainer is added or removed. Example at the bottom of table in red. Below is how my spreadsheet is set up. I am new to the mrexel forum and not an expert by any means with...

Greetings! I'm creating spreadsheets to show how many people were "on the clock" at each hour interval for each day of the week. I'm currently adding the information manually, but it's incredibly time consuming, and as with the example below, the data keeps changing so I'd rather have a...

Hi, I have a s/sheet for entering time in format [h]:mm Is there a way a data validation that I can ensure users enter the time as hour : mins (using a colon) instead of accidentally using hour . mins ? Many thanks

Hi, Just wondering can someone help or point me in the right direction for this problem. I need to create hourly data from minute by minute data. I have a file with 2 columns, 1st the date and time (dd/mm/yy hh:mm) the 2nd is a number. I've used a pivot table, and grouped the data by year...

I have weather data for a year that I am trying to average based on the hour. My averageifs function keeps giving me a #DIV/0! error and I can't figure out why. Any help is appreciated. Equation: =AVERAGEIFS($C$2:$C$11085,$I$2:$I$11085,"="&R2,$K$2:$K$11085,"<="&S1,$K$2:$K$11085,">"&R1)...

Hello, I'm trying to construct a formula that basically does this. I'll keep it simple. If cell A1 has "x" then G1 = "Blue" but if cell A1 and B1 both have "x" then G1 = "Blue Green" but if cell A1, B1, and C1 have "x" then G1 = "Blue Green Red". How can I do this? It' confused me for the...

I am trying to create a worksheet for use by our company and a customer. By contract, we bill for time elapsed in increments of quarter hours with a measure of time that is free and a dollar amount per quarter hour only for full quarter hours. For example, 8am to 5pm with an hour that is not...