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)

 

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



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 ?

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>