# timesheet

1. ### Multiple timesheets in tabular form to list form?

Here is what I have... A supervisor updates 1 timesheet for every day of the week (7 total) Each time sheet is saved under the same sheet stacked vertically (see sheet picture) At the end of the week the data from these 7 individual timesheets must be summarized as a list of records on another...
2. ### Timesheet Calculation

How can I complete this timesheet? I need Total Time worked (End Time less Start Time less Break) and Total \$ Due. I've tried it with the Break as minutes or hours or x24, formatted as h:mm or 0.00. I just can't get there. Can you help? Date Start Time End Time Break (Minutes) Break (Hour)...
3. ### Code to create a pop-up window with a text field - entries should be logged in a sheet

Hi Everyone, Semi new to VBA code but always hopeful to learn something new. At my previous company, we had a time management software that pop-up a window asking "What are you doing now?" but at the new place the IT security issues are so great (can't get assess to Task Manager) that they...
4. ### Resetting table based on day

First off, I'm really not experienced at all, just downloaded a free template from a website and just edited it and added a few simple formulas to suit my needs. So, I've got a timesheet that supposedly tracks the start time, end time, project name and all those things, mind you, not a weekly...
5. ### 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...
6. L

### Timesheet

Hello, I am trying to set up a simple time sheet tracker. How can I enter start and end times and then total the hours for each task. I tried in the below example but appreciate any help on this. Thanks Excel WorkbookABCDEFGH3Time Charged To4A/NDateAFR NumberShop OrderOtherStart TimeEnd...
7. ### Timesheet: calculating total, regular, ot and pto hours

Hi, We use Excel for our timesheet. The formulas work well, except for the PTO (Paid Time Off). We can't get it to add to total hours without adding to regular. Here are the forumulas: Total Hours: =ROUND(IF((OR(B16="",C16="")),0,IF((C16<...
8. ### Entering numbers is very slow

Workbook with 3 sheets: Timesheet, Charts, Data. ONLY the Timesheet when I enter a number or time, calculation is slow (~5-6 secs). It does not happen with alpha characters. Dimension for Timesheet is A1:AG566 A few vlookups and many if statements. The thing that puzzles me is this happened...
9. ### Calculate Overtime with multiple criteria

I am trying to make a timesheet that calculates overtime with the following criteria... 1. Overtime is after 8hrs on any given day. 2. Overtime is after 40hrs/week...consideration to the after 8hr criteria to ensure not duplicating overtime. 3. The after 40hrs/week overtime criteria changes if...
10. ### Overtime payroll sheet nightmare!

Hi I am trying to create an overtime sheet for my Hospital's salaries department and I am stuck! They need to have an out put of the exact hours worked (eg 09:00-17:00) for each day. Some people my work onsite in the hospital on several occasions per day so the exact hours for these need to be...
11. ### Average calculation of workhours - notice

Hello, I am trying to make a formula that lets me know when an employee needs to have time off (by law there is a maximum amount of hours they can work in an eight week work period). There are different values for different shifts: Day: 9 hours Evening: 9 hours Night: 7,5 hours Free: 0 hours...
12. ### Timesheet

Hi all, I'm new to the forum so hi and Thankyou for any advice. I am currently working on a timesheet for my partner, the problem I have is the way the sheet works I have a column that accumulates any flexi time over 7 and a half hours but she has started doing half days on Wednesday only so I...
13. ### Excel Timesheet minimum hours

Hi, Sorry bit of a newbie here!! I am making up a new timesheet for one of the departments in my company. Employees in this department get a guranteed payment of 6 hours per day, even if they dont work 6 hours that day so i have used the formula...
14. ### User Form - Kept in sharing - asking MsgBox to User - Solution required

Hi Guys, I have a new query on VBA Form.. I have made one timesheet tracker. on sheet3 button placed, where user need to click to open timesheet tracker userform. (this is one time activity) on sheet1 (besides to sheet3), all the data on userform saved in this sheet. Everything has...
15. ### Rota deducting lunch if shift over so many hours

So I want to get a total amount of hours worked in a day, which takes away lunch of 30 mins if someone works 6 or more hours, what formula do I use? Cheers
16. ### find record latest one

Hi All, I have assign x = TxtProjectID.value (text box) x value are in another workbook called "Timesheet Data" in Col E, with same directory. x = numeric data. I have multiple rows in "Timesheet Data". this x value information may exist multiple of times. What I'm trying to do... The...
17. ### Calculating how many hours taken between shifts

I have been looking all over the web for something similar to what I am looking for but have not found anything so far which suits what I need. I am creating a time sheet where colleagues would input data for each employee, where they worked, start time and end time. As part of the law, we...
18. ### Elevate user folder rights from an application

I have a VBA Excel-based timesheet program that allows employees to submit weekly timesheets. The application itself takes charge of creating each weekly timesheet and saving it to a specific network location (ActiveDirectory). At other times, the application also needs to be able to read...
19. ### Time Sheet Calculating Daily Hours Up To 40 Hours

Hi I have been trying to figure this out for weeks. I need my total daily hours in my regular hours column to only calculate up to 40 hours then anything over 40 hours to total in in the overtime cell. Right now it just totals the total work hours worked for a day in the regular hours, but I...
20. ### Create a Timesheet in 60 minute format

I need to create an excel timesheet to keep track of my temp employee. Details... Monday - Friday Work Week 1 hour unpaid lunch Need to keep track of total hours for week (in 60 minute formula not 100) Example: need it to say 7:50 instead of 7.83 Also, Since she is temp, her contract is for...

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

### Which adblocker are you using?

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

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