Get instant live Excel expert help with Time and Date Functions

i need to keep track our hours worked per day to accumulate 1 hour sick time for every 30 hours work. I need keep the total hours worked accumulating to pick up this 1 hour for every 30 hours worked until they reach a total of 40 hours sick time. I have another spreadsheet to maintain the usage of these hours.

Hello, I am working with a large temperature data set which has data points at certain intervals apart. The time intervals change throughout the data set and I was wondering if there was any way I could bin the values so that they are averaged to every hour as opposed to the random intervals which they are at now? The Date Time data has a (M/D/YY H:M) setup

I need a formula that calculates break times for a rota. If someone works anything more then 7.5 hours, 30min break should be deducted UNLESS they work before 1pm and after 8pm, then 1 hour break should be deducted. So far I've managed to deduct 30min break automatically, but I can't manage to deduct 1 hour somehow. =IF((E6-D6)*24>=7.5,(E6-D6)*24 - 0.5, (E6-D6)*24)

Formulas to create Hour on Hour data based on WhenIWork schedule.

Count of active employees in each hour at parent zone based on WhenIWork file.

Count of active employees in each hour at parent zone based on WhenIWork schedule. (previous expert, please).

Count of active drivers in each hour at parent zones.

Count of drivers in each hour at parent zones.

I need a formula that correctly gives me the cost for hours billed. In column D11 it has how many hours I need to bill for (example: 2.00) I charge $250 for the first hour and after the first hour i charge $75 per hour. So if the total hours = 1.00 its just $250. If its 2.00 hours then its $250+75. If its 3.00 hour its $250+75+75. If its 1.42 hours then its $250+31.25 (as its not a full hour)

I'm trying to extract day of the week from a time stamp to a new column and then the hour of the day from the time stamp into another column