| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Military Time
I need a formula so when I type in 2:00 PM it gives me 14:00. Or when I
type in 7:00 PM it gives me 19:00. Also need a formula to add the military time. For example: If I come to work at 08:00 AM and leave at 5:00PM (17:00 PM) it will give me the amount of hours worked. Thanks Dukey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| Converting Standard Time into Military Time | Excel Discussion (Misc queries) | |||
| Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
| Military Time | Excel Worksheet Functions | |||
Threaded Mode
