Download Excel Start File: [ Ссылка ]
Download Excel File: [ Ссылка ]
See how to Convert Date-Time Values in the form YYYYMMDDHHMMSS to proper date time Serial Numbers that Excel understands using TEXT function & Custom Number Formatting: 0000-00-00 00\:00\:00
1) TEXT converts value to text
2) Custom Number Format: "0000-00-00 00\:00\:00"
3) Math operation converts Text Number back to Number
4) Custom Number Format Cell to display as desired
Tricks learned from barry houdini @ Mr Excel Message Board and Leonid Koyfman @ YouTube
Reference videos:
Excel Magic Trick 721: Convert Text Time Numbers Without A Colon To Time 0655 into 06:55 AM
[ Ссылка ]
Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00")
[ Ссылка ]
Ещё видео!