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|
Entering only the last 2 digits of a yearWhat happens if I only enter the last 2 digits of a year?
Excel uses a 29/30 cut off point between 1900 and 2000.
Excel will try to read your mind. With Excel 97 and Excel 2000 -
It considers all years from 0 to 29 to belong to the 2000's.
It considers all years from 30 to 99 to belong to the 1900's.
If you type Jan 1 45 - excel calculates it as 1945
If you type Jan 1 02 - excel calculates it as 2002
Please note: this does not apply to the "date" worksheet function.