free timesheet
light, easy training on calculating hours and minutes in excel

Excel Timesheets Add & Convert General Knowledge
Part A. Create a basic Excel Timesheet Add up Hours in Excel How does excel calculate hours
Part B. Insert Unpaid Lunch Breaks Convert Conventional Hours into a Decimal # How does excel calculate dates
Part C. Calculate Overtime Pay Convert Hours and Minutes into Minutes Express Log in and Log out in Excel
Timesheets for Night Shifts Average Hours ignoring Zero's and Error Values Entering only the last 2 digits of a year

how does excel calculate hours: How does Excel understand AM and PM hours.

Short Answer:

Excel calculates hours as their fractional value of a 24 hour day.

Long answer:

In excel's mind, 24 hours is 1
In excel's mind, 12 hours is 0.5
Therefore, when you enter in Excel 6:00 am, Excel considers it 0.25
When you enter in Excel 6:00 pm, it thinks of it as 0.75 


timesheet templates
Template Library New to Excel? Confused? Download our ready to use Excel Templates Timesheets.
See our Templates
timesheet calculator
Time Card Calculator Free Online Timecard Calculator. Easy and fast to calculate timesheets.
Try it out!
excel how to
excel how-to Learn how to add up hours and create your own templates in ExcelExcel Training