# hours

1. ### Calculate daily hours

I have a spreadsheet that has hours worked by a job on a daily basis. Example Monday Framing, Drywall, Stocking, Clean up 2, 4, 2, 3, 5 = 16 hours worked 8 hrs regular 4 hrs overtime 4 hrs DB time How do I calculate the number of hours for overtime, and double-time? It's a rush job and...
2. ### SUM IF Duration Is Between Certain Values

Hi All! Could you please kindly advise as to how to sum duration values that fall between certain ranges? My custom format is set to [h]:mm and cannot be changed. Let me illustrate what I'm trying to do with an example. Columns A & B usually contain 9:00 & 17:30 respectively, however, at...
3. ### Need To Get Elapsed Time Between 2 Dates During Working Hours ( All Days Included )

Hi I need to get the elapsed hours between 2 dates considering that working hours is from 8 AM To 4 PM all days included ( no week ends or holidays ) example : A1 : 11/11/2019 09:31 AM B1 : current time { now() } will be used
4. ### Formatting with Multiple/Varying Conditions

Hi Everyone - Need some help in finding a way to have a cell change color based off a drop down, and each time that drop down changes, it will potentially change the color of the cell, based off of the current letter in the cell. See below an example of a few rows. My book has 54 rows, but if we...
5. ### Can a letter have a value in a cell?

<tbody> POSITION POSITION TOTAL HOURS AMC AMC 8 </tbody> IF POSITION AMC EQUALS 4 HOURS HOW DO I GET EXCEL TO DO THIS FOR ME?
6. ### Time calculation run hours per day

I need help to get a calculation of run hours per day for 3 units, based on generator breaker shut/open times. We currently use an integration over time to count the time for the breakers closed, but this gets messed up when the computer is rebooted or updated. I need to calculate the decimal...
7. ### Need Help with Formula / Skipping Lines

Hello, I am trying to create a sheet in Excel to pull Hours from another sheet to upload into a system as a CSV file. I need a formula for hours that would pull in the Reg Hours and then say if the Overtime cell has a value then it will make a second line for that same employee and pull in those...
8. ### VBA - Prioritize, Generate and Fill Numbers with multiple criterias

This is my first post and was hoping someone could help with my dilemma. I stumbled upon the Solver function in my search but I am not familiar with it and have no idea how to implement it. I will try to be as clear as possible. My client wants my company to use a particular time sheet. I...
9. ### From excel timesheet create a import file csv

Hi, really hoping for some help please. I have a excel timesheet which details hours worked against different pay elements. For example , columns would be ... Ee no., name, no.of hrs, hourly rate, total pay. Header above theses columns would be PE Basic pay( 88). Following to the right , the...
10. ### How to convert hours worked on a task into percentage

I'm working on a time study. I need the formula to convert numbers of hours worked on a task in an 8 hour day into a percentage.
11. ### Creating a Time Card with O/T

New to spreadsheets. I have created a bi weekly time card based only on hours worked (no clock in clock out fields). I have 3 columns for hours (the actual time worked per day, O/T per day and Reg Hours per day with the O/T subtracted. What I can't figure out how to do is create a code so if...
12. ### Complex Excel Vlookup or Other Solutions Welcome

Hello, I am trying to create a solution to point out employees on a spreadsheet that need to be researched for hours processing. When they have over 40 hours they go on a spreadsheet we have to look at their worked location and hours columns. I was thinking either a Vlookup or maybe even a...
13. ### Calculate Work-back Schedule - Business Days and Hours

Hello, I am trying to create a work-back schedule where you enter a launch date/time and the delivery dates of that project are calculated based on hours working backward from that launch date. The working hours should only be business days and hours (M-F, non-holidays, 9am-5pm). The formulas...
14. ### VB.NET by using console

Guys help me to make this code: A company has 10 employees, they all get paid on hourly basis. For each employee the company keeps h employee name, number of hours worked every week. Every employee gets paid weekly. Gross earning is calculated by multiplying number of hours worked by pay per...
15. ### Over 40 hrs

So I am doing a work sheet that will calculate pay for employees. The employees are paid from 8 to 5 during the week, and are on call for a large part of their pay period. When they are activated, their pay starts and has to be calculated until the job is complete. My problem is their pay will...
16. ### Compute Night Differential, and Night Differential OT

Good Day! How can I compute the number of hours between a specific range, For example, an employee has timed in at 6:00 pm then timed out at 3:00 am the next day. What formula can I use to compute the number of hours that is only within the Night Differential, 10:00 pm to 6:00 am. Note: Night...
17. ### Subtracting 30 minutes only if parameters are met...

I have a time sheet calculator that i developed to calculate summations for me in respect to total hours worked for an individual. I stumped myself and believe I am over thinking the equation. Essentially i need it to subtract 30 minutes for a break if certain conditions are met, 8 hours or...
18. ### Display time in hours?

Is there a way that I can enter a time value from a stopwatch as hh:ss and have it displayed as hours (hh.hh)? For example, I'd like to enter "7:45" in a cell and have "7.75" displayed in that cell. I know I can do it by entering the "7:45" in A1 and use a formula in B1 (=A1*24) to convert it...
19. ### How to filter data in a Pivot Table when data is Sum

I have a fairly simple table that I have created a pivot table for. I can't seem to figure out how to filter the pivot table to only show certain data (excluding sub totals and totals). Here is a screen shot of the info(I have removed subtotals and totals): I need to filter the data to show...
20. ### Miuns Non Working Hours

I have this problem, here. Now in a column A I have the End time and in column C in have the start time. Am bit confused with the non working hours From Sun to Thu it is 13:00:00 hrs -- Non working hours On Friday it is 15:00:00 hrs -- Non working hours On Saturday it is 12:00:00 hrs -- Non...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back