Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time
Is it possible for me to enter "1353" in cell A1 and it will automatically display 1:53PM in cell A1? This would help a bunch. Thanks. -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502566 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time
Chip Pearson has some code that may help you:
http://cpearson.com/excel/DateTimeEntry.htm If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm exsam21 wrote: Is it possible for me to enter "1353" in cell A1 and it will automatically display 1:53PM in cell A1? This would help a bunch. Thanks. -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502566 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time
Thank you very much! -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502566 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
Time and motion chart | Charts and Charting in Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
in excel totaling weekly hours military time | Excel Worksheet Functions |