Get instant live Excel expert help with Time and Date Functions

I am attempting to add a 24 hour time period between 11:59 pm through 12 am the next day and it only gives me 23 hours and 59 min i cant get it to give me the one extra min i need to display

IF the hourly rate + 1.45/hours >10.90 then 10.90 * hours * family % (I think) the IF hourly rate + 1.45/hours<10.90 then hourly rate + 1.45 *family % (I think) So what I am trying to find out is... 10.90 per hour is the maximum rate the government will pay. if the fees per hour are over this then it needs to be limited to 10.90 per * family's %....if the fees (hourly rate + 1.45) are less than 10.90 per hour... then hourly rate + 1.45 * family %

I was working with a specific expert and they were very helpful. I want the same expert as I had 1 hour ago. building a reporting form and he was making it work! Please help!

Hi, I am trying to build a chart, and need some help. The chart is Day of Week, Half Hour Intervals, Total calls during interval. I have 3 columns in the chart. I need the X axis to show day of week at the bottom, and interval above that with the Y axis being total calls in a line chart. I can provide a screenshot if necessary.

I created a Timecard where I am using the 2nd tab (Import Spreadsheet) to calculate the hours and populate in such a way so as to allow my Office Administrator to simply copy/paste the data from the 2nd tab directly onto a spreadsheet that is then uploaded into our payroll system. In our world, Holiday hours are counted in the math when computing overtime pay. In other words, Holiday hours are placed in the 40 hour "bucket" of regular time and can then bump any hours > 40 out of Regular and into Overtime. There is more to explain, but I've run out of room. Website won't let me go > 650 characters.

I need to make this graph on Excel: Left Y-axis: Blood pressure (Values 0 to 100) Right Y-axis: Vasopressor dose X-axis: Time: Earliest value 2 hours before vasopressor start time, then 24 hours starting at 0 with a dotted line depicting the start of Angiotensin II, and a dotted line at hour #24 depicted the end of Angiotensin II Data Series 1: BP values Data Series 2: Vasopressor #1 dose (Norepi) Data Series 3: Vasopressor #2 dose (Vasopressin)

I've calculated total hours worked in a shift by taking the current time and subtracting it from an employee's start time. Now I want to take the total dollars collected by that employee and divide it by the total hours worked I calculated to give dollars collected per hour but I keep getting $0/hr. Can you help me calculate this correctly in Excel?

Hi, how to calculate the sum of time difference for different person in term of hour minute and sec between the start time and end time?

I am trying to calculate the number of hours when wind is going a specific direction (0-45, 46-90, 90-360 in degrees) as well as the average speed +direction. Under YR-MODAHRMN, it is represented by ONE hour. How will I be able to create a formula for these?

I have a problem with rounding down times to the nearest hour using the FLOOR function. It rounds down full hours by an hour