| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date reformatting question
Clarification.... I wrote:
The problem is made complicated by Daylight Savings Time. GMT is not adjusted for DST. [....] Alternatively, you could have a cell (e.g. D1) with 0 (not DST) or 1 (DST), then use the following formula: =LEFT(A1,19)-TIME(8-D1,0,0) [...or...] =LEFT(A1,FIND(" ",A1,1+FIND(" ",A1)))-TIME(8-D1,0,0) You should then copy the converted times and paste-special-value so that you have constant times again. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retain custom date format "text" when pasting or reformatting data | Excel Discussion (Misc queries) | |||
| Excel reformatting a date axis to January | Charts and Charting in Excel | |||
| Stopping Excel from reformatting data as a date? | Excel Discussion (Misc queries) | |||
| US date needs reformatting but not recognised by my UK computer | Excel Programming | |||
| Reformatting question | Excel Programming | |||
![joeu2004[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
