Get instant live Excel expert help with Time and Date Functions

Hi, I need help with a function where I can get the first log time in a series of batches which has a cycle time of 1 hour for example.

I need to combine the two charts on Sheet 3 into one. the axis should be irradiance vs hour of the day.

Please help me solve the case below : Overtime calculation rule in Indian banks are : 1st 2 quarter hour .... 100% of hourly wages Next 4 quarter hour .... 170% of hourly wages Next 4 quarter hour .... 170% of hourly wages Now, if total quarter-hours of overtime is 1/2/3/4/5/6, how quarter-hours are to be divided into each segment in an excel sheet by using a FORMULA : Total quarter hours 1st 2 qr Next 4 qr Next 4 qr Rest qrtr e.g 1 or 5 ? ? ? ?

I have to create a schedule which incorporates lunches automatically (half hour for 8 hours or more worked) The schedule only has time in and time out, but I need excel to automatically deduct the lunch break depending on the circumstance: If you worked less than 8 hours, no time is deducted. If you worked 8 hours or more, 0.5 hour lunch is deducted

Hi Guys - How can I convert the below into time? They're in quarter hour intervals and I can't find a formula to convert them. 7 7.15 7.3 7.45 8 8.15 8.3 8.45 9 9.15 9.3 9.45 10 10.15 10.3 10.45 11 11.15 11.3 11.45 12 12.15 12.3 12.45 13 13.15 13.3 13.45 14 14.15 14.3 14.45 15

need help with this. do in an hour. please help i have a list on what i need to do but dont know how to do it

I need help taking a column G and turning it into a column chart. I want to see the number of results that are less than 1 hour, then the number of results every hour.

summary level employee bi-weekly report, column A employee name Column B total hours worked 67:34 Column C OT over a 40 hour work week and totals at the bottom of columns B,C

I have a spreadsheet of Incident tickets with opened dates from all of 2018. I need to break down the tickets so that I can break it down into days of the week (Monday,tuesday,wednesday, etc) and then the average number of tickets opened for each hour of that day for the whole year (example - for monday 1am - 2 am - average = 4 tickets). I tried pivot tables but I can't format the days of the week correctly to show as monday, tuesday, etc.

I need a conditional formatting formula that includes color highlights at 150 vehicle hour intervals (green, yellow & red). The spreadsheet covers the span of a month as we enter data on a daily basis. The cells are running totals of the day prior but when the interval of 150 is reached, we would like to see a color highlight indicator for action.