1. N

    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.
  2. G

    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...
  3. H

    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...
  4. M

    Calculating Hours Worked and breaks taken

    Hello I thought I already posted this question but couldn’t find it anyways here I go I am working on a weekly staffing schedule and it has the follow info type C13 = start time ( 8:30 Am) D13=End-time (5:00 PM) E13 =Hours worked ( subtracting breaks with the following rules ) Works < 6...
  5. L

    subtract time

    Hi I want to find how many hours a user worked. The start time was A1= 10:00 pm and shift finished B1=1:00 am, so this user worked 3 hrs, so when I did C1 = 24 * (B1-A1) I got ################....... How that can be fixed. Thank you very much
  6. M

    Macros stopped working?

    Hi Guys, I recently got some great advice on here regarding a function I wanted to get working. I added some code to the vb module, referenced it back in the worksheet and all worked great for a couple of days. Im now opening the *xlsm and none of the calculations are working, just #NAME ...
  7. W

    Excel closes automatically

    I have a new desktop computer and since I started using it any Excel file with a macro will run the script and then just close Excel. There are no errors, nor does it matter which Excel workbook I use. These previously worked fine on a different computer, and other colleagues are able to use the...
  8. M

    Sumif with index and match if two criteria are met

    Hi, Looking help in constructing a formula to help me interrogate a large data area which if 2 criteria or met then sum the associated hours worked. Basically I want a summary report that gives me the total hours worked by a particular grade for each month as we go through the year. Below is...
  9. B

    Not a trick question, what is wrong with this formula

    So I have a column of formulas. I clicked and dragged to autofill the formulas and at some random point, it stopped working. Can anyone see a difference? =IF(A123=0,0,VLOOKUP(EQUIPMENT!A123,EQUIPMENT!$L$3:$P$2888,5)*B123) This is the last one that worked...
  10. U

    Format the 3 numbers in a column closest to ZERO

    Ok so here is what I'm trying to do. Here are my numbers .. I want to highlight the three lowse numbers closest to zero. Which would be numbers 0.1 , -.08 and 0.9 ... I have tried several formulas but nothing has worked. Any suggestions or the right conditional format formula would be...
  11. A

    Countif Until

    Hi I’d like to average hours worked every 5 days but need toexclude days where no hours have been worked. Was playing about with AverageIf to achieve this and wouldn’t be aproblem for the formula in cell below (answer is 9.6). However, if I drag the formula along (Formula 2), the average will...
  12. C

    Time as duration and product/hour

    Hi! I have the old problem of getting Excel to understand time as duration, not time of day. Basically, I want to calculate how many pieces a worker does at the end of day, knowing: pieces/hour and time worked (like 1h30min) I think I got it to understand time, but can't get it to do the...
  13. M

    Need to count blank cells between two non-blank cells

    I have a sheet for the days of the week, and hours within the day. Every hour worked has a '1' in the corresponding cell. Every hour not worked is blank. I need to calculate the number of hours between worked hours. <colgroup><col span="5"><col><col span="3"></colgroup><tbody> Monday Tuesday...
  14. L

    Frustration level building - any thoughts?

    I have had these lines of code in a program for two years. Sheets("ShiftReport").Select Range("B2").Select ActiveCell.FormulaR1C1 = CDate(frmShiftOnDuty.dtpShiftDate.value) It has worked without any issues, in fact this very section of the code ran yesterday. No code changes...
  15. C

    looking for a simple solution

    I am building a rota and so have 52 work sheets titled week1, week2, etc... each sheet is identical in layout, similar to below. Assume that cells here run from A1:O5 What I want to do is have all the dates update across the 52 sheets when I enter the 'start' date in week1 Currently I am just...
  16. J

    Question - Data extrat from one workbook into another

    Good Day excel Guru's! I am a novice with excel but highly addicted! My issue is this: I run a small business and I would like to track my payroll from several departments into an easy to analyze workbook. The trick is that ADP generates a weekly report in Excel format (which ill try to...
  17. N

    macros enabled workbook compatability issues 2013 vs 2007

    Hi - looking for help!! I designed an 'macro enable excel workbook' based health assessment tool a few years ago. It worked fine on versions of Excel as far back as 2003. I have just updated some of the content. A friend helped me with some coding to update a few features. He worked on it...
  18. F

    Timesheet Calculation

    Good Day I have this this Spreadsheet that calculates time This is the format I have Start Time Lunch Taken End Time Hours worked 7:50am 00:00 11:45am 3:55 4:45pm 00:00 7:30pm...
  19. M

    Trying to Perfomr Data valaidtion if # exceeds value in other cell.

    <tbody> A B C D E F 1 This Wk Hrs Worked Prev Wk Hs worked Prev all Hrs Worked Estimate hrs cumulative hrs New Total Hs 2 2 4 5 10 9 (sum b:c) 11 3 4 </tbody> Trying to understand how I can perform data validation if exceed value in...
  20. J

    information provided by dates

    ill try to keep this simple. basically i have a start date and an end date of an employee. the first thing i want to do is work out how many days a person has worked over a quarter. so i need something that will work out how many days there are in jan feb and mar and add these together. then do...

Watch MrExcel Video

This Week's Hot Topics

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
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

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 "".
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