Excel Military Time Conversion Table - DOWNLOAD NOW
| 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 | 00 00 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).
For a simple, easy to use Military time converter - see our downloadabe Military Time Calculator
table with examples of military TIME conversion:
| 0745 | 7:45 AM |
| 2349 | 23:49 PM |
| 0018 | 12:18 AM |
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.
Examples:
9:00 (9--colon--00)
17:00 17--colon--00)
download military timeshEets: Excel Military Table - Weekly TimesheetExce 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.
