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)

For more information refer to the following link:

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

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 ?