Home |
Search |
Today's Posts |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
military time set up
Did not work. the formula has an error at "00\
"Pattio" wrote: I have reviewed all the topics on setting up military time but have yet to find how to set up the minutes in 100's. Example: I need the time to show 13:75 or 1:45 standard time. I can set up the military hours but not the minutes to show in 100's. How do I do that? It should show 13:75 for 1:45 or 06:25 for 6:15. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
Is there an XLS function to convert std time to Military time? | Excel Worksheet Functions | |||
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 |