You are here: HomeExcelTutorials

# How to calculate time worked: Start time, end time, lunch break

## How to calculate time worked: Start time, end time, lunch break

Price: FREE

I have a sheet which has the start, stop and time taken for lunch breaks.
I want to calculate the total time worked such that I have the hours worked. So if I worked 7 hours and 30min then the total time would be 7.5hrs. But I am not sure how to take into account the lunch break time (see enclosed sheet).

Visit publisher's web-site: How to calculate time worked: Start time, end time, lunch break

Category and Tags: ExcelTutorials :

## Related Tutorials

### Gantt chart

Free: Yes
Tags: Excel › Charts

Is there a way to break a chart in between a duration to show another
Eg, column 1 is the time start (08:30), column 2 is time end (17:30), column 3 is duration (9:00) between column 1 and 2. However on column 4 is lunch break start time (12:00) and column 5 is lunch break end time (13:00). Is there a way to show the lunch break on a gantt

### Find Best Available time

Free: Yes
Tags: Excel ›

so I have a spreadsheet with many employees listed.
Each employee has columns for shift start time, break1 start time, break1 end time, lunch start, lunch end, break2 start and break2 end.
I also have a list of meeting times. Each meeting is 50 minutes long.
I am trying to use a formula that will look at all of the columns given and find where the employee is not on a break or lunch, and is on their shift that matches one of the meeting times. -Trying to enter meetings without moving breaks or lunches.
Is there any way to find this without using a good awful number of if statement.

### How do I set up a time sheet in Excel?

Free: Yes
Tags: Excel ›

What I need to do is have people enter the time they start, what time they leave for lunch, come back from lunch and leave at the end of the day. I want Excel to automatically calculate the number of hours and minutes for each of these so that I can then add up the total number of hours and minutes worked each day.
I am having a hard time formatting the cells (do I format them as time or numbers?) and then whenever I try to add or subtract hours, how do you deal with the 12:00 hour, which then seems to mess up any formulas. For example, if someone clocks in at 7 and goes to lunch at 1:30 - how can you create a formula where Excel will get the correct answer of 6:30 minutes worked?

### Check time in cells to see if it goes across lunch

Free: Yes
Tags: Excel › Functions

Is there a way to check the time in two cells to make sure that it doesn't count a lunch break. ie
Start time is 8:45 end time is 16:25 so I need to subtract 30 minutes, however if I run an if statement
and say use >12:30 if the job starts after 12:30 it will still subtract 30 minutes which I don't want.
Also If it ends before 12:00 again no time subtraction.

### Subtracting Times

Free: Yes
Tags: Excel ›

I am making a timesheet but having trouble with subtracting times.
I have subtracted 3 times away (start time / lunch break / end time) to calculate hours worked.
I have then taken this from the Contracted hours to see + / - time worked.
However when you look at the calculation of the + / - time worked as a number, there is a a variance at the 16th number past the decimal point when they should be exactly the same (for 07:35 - 07:35). This causes the timesheet to display + and - values for 00:00.
Please see attached excel file on the Example sheet dates 26/01/2011 to 27/01/2011. I have no idea why there is this discrepancy.

## Related Applications & Scripts

### CF Time Span Calculation

Free: Yes
Tags: CFML › Excel Date and Time

Script allows developers to easily embed the functionality of calculating end time from a given start time and span into in 1/2 hour increments.
REQUIRES Cold Fusion 5.0 or MX to run- Uses "CreateTimeSpan" to translate both start time and time span into minutes. That way only a simple addition is required to determine end time.-"TimeFormat" is then used to return the start time and end time back to a HH:MM based time format.-Several of the "TimeFormat" formatting options are provided with this script.

### Lunch Break Error Page XML

Free: No
Tags: Flash › Excel Web Layouts

Complete, animated and sounded coming soon under construction HTML page template with XML custom external logo, music, adjustable multiline textblock with tags support and alternative URL link. Silhouette dancer working man from sign with interactive animation centered in browser window. Your logo is clickable with custom URL .

### ASP Daily Scheduler Calendar

Free: No
Tags: ASP › Excel Calendars

The Daily Scheduler is a web calendar that can be installed directly from the Adobe Dreamweaver's menu and that includes a web-based admin system to edit the entries and control the settings.
This calendar has the following features:
Allows to create entries for each day, indicating, optionally, start and end times for each entry.
Supports three types of entries:
With both start time and end time defined
Only start time defined
Without defined start or end time
Supports recurring events on weekly basis, ex.: all Mondays at 09.00 AM, all Saturdays at 10.00 PM, etc. Note: only recurring events of weekly frequency are supported, without exception, excluding any other type of recurring events (more information below).
Can be used to visualize calendar entries on a public site, where additional information will be shown in floating panels.
Can be used as a reservation calendar. If inserted into a reservation form, can be used as a date picker to select start and end dates.
Includes an HTML (WYSIWYG) Editor, to edit calendar entries.
Supports 12 hours (AM/PM) or 24 hours format.

### ASP Time Management

Free: Yes
Tags: ASP › Excel Calendars

Time Management Software: designed to be an easy to use time management and calendar tool. Keep your schedule up to date online. Calendar has been updated!
Features: simple to use, clean interface, easy setup, add multi user support, csv export, database backup

### AtomJump Time-to-call Calculator

Free: Yes
Tags: Web Services › Excel Date and Time

Your customers from other time-zones will be going elsewhere if they try to contact you outside your office hours.
A timulator will put a stop to this, by showing your open hours altered dynamically to each individual visitor, based on the time-zone they're in.