|
|
#1
08-25-2016, 10:38 PM
|
|||
|
|||
time formatting
How can I format cell A1 so that when I enter the time in military format in A1, it will display as standard time in A1.
Example:I would like to enter 1400 in A1 and have the same cell display 2:00PM 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time
|
CPSmith | Excel | 1 | 03-26-2016 02:48 AM |
| VBA Word Table - Select More than 1 Column at a time - Apply Formatting | jc491 | Word VBA | 12 | 09-24-2015 06:03 AM |
| Help - Run-time error 91 - VBA for inserting and formatting text depending on style | mtrborges | Word VBA | 2 | 02-08-2015 11:35 PM |
| Formatting Merged Time Values Between Excel & Word | JennEx | Mail Merge | 1 | 07-12-2012 02:54 PM |
|
Cell formatting for time - Excel 2010
|
PomDave | Excel | 5 | 09-05-2011 10:49 PM |
Windows 10 
Office 2016
Threaded Mode