PLEASE NOTE: Military time does not have a Colon (:), but 24 hours clocks do!
|Military Time||Regular Time||Military Time||Regular Time|
|01:00||1:00 AM||13:00||1:00 PM|
|02:00||2:00 AM||14:00||2:00 PM|
|03:00||3:00 AM||15:00||3:00 PM|
|04:00||4:00 AM||16:00||4:00 PM|
|05:00||5:00 AM||17:00||5:00 PM|
|06:00||6:00 AM||18:00||6:00 PM|
|07:00||7:00 AM||19:00||7:00 PM|
|08:00||8:00 AM||20:00||8:00 PM|
|09:00||9:00 AM||21:00||9:00 PM|
|10:00||10:00 AM||22:00||10:00 PM|
|11:00||11:00 AM||23:00||11:00 PM|
|12:00||Noon||0000 or 24:00||Midnight|
In the US and Canada, writen military time usually does not have a colon to separate between hours and minutes. However, the 24 hour clock used in most of the countries of the world, do use a colon (hh:mm format).
table with examples of military TIME conversion:
excel time sheets that use military time:
All you need to do is enter the information in RED, and Excel will calculate the hours and pay.
NOTE These timesheet templates require you to enter the hours in an HH MM format.
Exce Military Weekly Timesheet Table with Lunch Breakl
For one-time quick calculation - try our Online AM/PM Time Card Calculator
SEE MORE EXCEL TEMPLATES:
Excel Templates with Lunch Breaks
Excel Templates with Overtime
Excel Timesheets with Sick and Vacation Hours
Templates to Add and Convert
suggest new excel templates Suggestions from people like you helped us develop the above Excel templates. We build Free Weekly and Montly Timesheets.