read only numbers from mixed cells in excel
조회 수: 1 (최근 30일)
이전 댓글 표시
i want to read the following coloum:
9:28:53.321 AM
9:28:53.421 AM
9:28:53.521 AM
but without the AM. thanks
댓글 수: 0
답변 (1개)
Star Strider
2017년 5월 13일
Read it with the ‘AM’ and ‘PM’, then use the datenum or datetime functions to make the appropriate time-of-day conversions to 24-hour time.
Please never discard useful information!
댓글 수: 2
Star Strider
2017년 5월 13일
You can get them in the same format by first using the ‘AM’ and ‘PM’ to be certain the times get imported and converted correctly. You can then use whatever format you want for the output. For ‘AM’ times, the hours will be unchanged, for ‘PM’ times, 1 PM will become 13, for example.
There are many possible output formats from the date and time functions. You do not need to specify ‘AM’ and ‘PM’ in the output unless you want to.
참고 항목
카테고리
Help Center 및 File Exchange에서 Dates and Time에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!