# Creating a Timesheet

Problem: Creating a timesheet which calculates the number of hours worked each day and a sum of the total hours worked. Solution: Create 3 columns containing the following data: Date (column A), Time In (column B), Time Out (column C). In the 4th column (Number of Hours), enter the following formula: =(C2-B2+(C2 To sum the total number of hours worked, use the SUM function as shown in the following formula: =SUM(D2:D7)

http://www.exceltip.com/excel-dates/calculate-number-of-minutes-between-dates-time-in-microsoft-excel.html
http://www.exceltip.com/tips/timesheet-calculator-in-microsoft-excel.html

## One thought on “Creating a Timesheet”

1. Dear sir/Missis
1. How to calculate the following shift: day and night for normal working hours?

Day shift
Time in Time out total hours
12:30 – 13:30 ?

Night shift
Time in Time out total hours
17:30 – 24:00 ?

Morning shift
Time in Time out total hours
1:00Am – 07:00Am ?

2. How to calculate the following shift: day and night for weekend & Holiday?

* Morning

Time in Time out total hours
08:00 24:00 ?

* Morning

Time in Time out total hours
1:00Am 7:00Am ?