Get instant live Excel expert help with Time and Date Functions

I was chatting with QI(?) about an hour ago and nearly solved a problem. I think I have the solution but have run into another problem. How do I get rid of "FALSE" - see attached spread sheet

I'm struggling with the sumifs function. I'm looking to get total of everything broken down by day and hour.

I need help creating a formula that will allow me to see based on 14 days how many people will be coming on each and every hour

I need to remove the values in the rows that correspond to the numbers 8, 9, 10, and 11 in Column C (values to be deleted are in columns G, I, & K). I had this same operation done about an hour ago so I can send the solution file as well if needed.

The cost of materials is $22.59. One person can assemble four per hour. You pay that person $10.25 per hour. The cost of packaging is $1.50 and it takes 5 minutes to package the product. You pay the person that does the packaging $10.25 per hour. All other costs are included in manufacturing overhead that is charged at 50% of the product material and labor. What is the total manufactured cost of the product?

This is a two part problem. A. Product Labor Costs You are making a new product. The cost of materials is $22.59. One person can assemble four per hour. You pay that person $10.25 per hour. What is the labor cost for the product? Did you say that the answer is $10.25/4 or $2.5625?

Consider what that $10.25 per hour person really costs you. You pay 6.2% social security and 1.45% Medicare on the employee’s pay. You have a 401K that you match 4% of the employee’s pay (assume everyone participates in the 401K). Your workers’ compensation t of the remaining 7 hours 20-minute work day, your employees’ efficiency is 74%. You do your best to operate with no overtime, but your overtime runs 5% (i.e., 5% of the hours worked in a year are on overtime and paid with a 50% premium).

I need a macro that would format the selected column as follows; the column lists hours worked in this format 45 minutes = .45, 3 hours and 40 minutes = 3.4, 1 hour and 1 minute = 1.01. I need to format this column so I'll be able to sum up hour and minutes.

need a formula to format values to the time format so I can calculate total hours and minutes. the current format is as follows: 45 minutes = .45, 1 hour and 1 minute = 1.01, 12 hours and 50 minutes = 12.5

what will be the formula for calculating if an employees work from 09:00 am to 07:00pm per day will be paid rs750/-, and after 07:00pm until 06:00 am will be paid rs.200 per hour, and befor 09:00am from 06:00am onwards willbe paid rs 100 per hour on pro rata basis for 30 minutes