 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.

Examples

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.   