Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format
Solved/Closed
Lschwa01
Posts
1
Registration date
Monday September 14, 2015
Status
Member
Last seen
September 14, 2015
-
Sep 14, 2015 at 03:37 PM
Blocked Profile - Sep 14, 2015 at 07:23 PM
Blocked Profile - Sep 14, 2015 at 07:23 PM
I have looked at dozens of articles, but they all talk about converting different forms of mm/dd... etc. to other similar forms. I want to chart blood pressure readings by date and time (different times on different days). If I had the date/time in an internal form, I could chart the day number and time (starting at day 1 at 00:00) for the readings. This will let me chart "real time", i.e., each day (horizontal axis) is the same width, and the time of the reading will be appropriately positioned horizontally within that width, with some days having no entries. I've tried DATE and DATEVALUE with no success. Any help will be appreciated.
Related:
- Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format
- Dd-mm-yyyy format in excel - Guide
- Convert number to words in excel - Guide
- Marksheet format in excel - Guide
- Convert m3u to mp3 - Guide
- Convert picture to shape powerpoint - Guide
1 response
Have you entered in the variables you are trying to enter yet? The reason I am asking is because, I just opened Excel, hit cell D1, and typed in "1/5/2015 1:13 PM", and the data stayed there as such. It did turn the 1 pm in to 24 hour 1300, but other than that, i would have been able to Filter by it as in the below screen shot:
![](https://img-16.ccm2.net/AOl1SfADtnVabOfV-aS4tsKMRkc=/440x/3da3cb7a8c4744ba87e879439dd13289/ccm-ugc/ff2rje1h5ejEfDtAc67-sorting-datetime.png)
Results in the following:
![](https://img-16.ccm2.net/LZ6tqvd4TLF14PfA5b9H_gzW1Co=/440x/03bc1b98d08c4abc9757fd06e1b0d615/ccm-ugc/DOG9IE6yaCQUWtiTFx-sorting-datetime1.png)
![](https://img-16.ccm2.net/AOl1SfADtnVabOfV-aS4tsKMRkc=/440x/3da3cb7a8c4744ba87e879439dd13289/ccm-ugc/ff2rje1h5ejEfDtAc67-sorting-datetime.png)
Results in the following:
![](https://img-16.ccm2.net/LZ6tqvd4TLF14PfA5b9H_gzW1Co=/440x/03bc1b98d08c4abc9757fd06e1b0d615/ccm-ugc/DOG9IE6yaCQUWtiTFx-sorting-datetime1.png)