| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to record time in Excel in military (0730) format?
Double unary minus:
a.. http://www.mcgimpsey.com/excel/formulae/doubleneg.html b.. http://xldynamic.com/source/xld.SUMPRODUCT.html -- David Biddulph "Neeraj Gupta" wrote in message ... On Aug 13, 4:29 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: The simple way of converting the 0040 to a time of 00:40 is to use =--TEXT(A1,"00\:00") and format the cell as time. -- David Biddulph Hi David , In the above formula what are these 2 dashes for...."=--TEXT" Regards Neeraj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change regular 24 hour format to military time in excel | Excel Worksheet Functions | |||
| military format of time | Excel Discussion (Misc queries) | |||
| Converting time as 7.5 (which represents 7:30 AM) to 0730 | Excel Worksheet Functions | |||
| getting military time format within excel | Excel Discussion (Misc queries) | |||
| DOS Data in Excel Format with Date and Military Time in same cell | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
