| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Format 0000 to 2400
Is there any way I can get Excel and VBA to show midnight, 0000hrs as
2400hrs?? Lloyd *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time Format 0000 to 2400
Hi Lloyd,
format, cells, custom 0000; -0000; 2400 0000"hrs"; -0000"hrs"; 2400"hrs" --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Lloyd Peck" wrote in message ... Is there any way I can get Excel and VBA to show midnight, 0000hrs as 2400hrs?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format custom number: C-0000-L | Excel Worksheet Functions | |||
| Difference between 2 dates&time(format 0000), and excludes weekend | Excel Worksheet Functions | |||
| trying to change 000-000-0000 phone format to (000)000-0000 ???? | Excel Worksheet Functions | |||
| Taking 1600-2400 and Converting to Time in different cells | Excel Discussion (Misc queries) | |||
| Phone number format from 000.000.0000 to (000)000-0000 | Excel Discussion (Misc queries) | |||
Linear Mode
