Convert fixed-width local date and time text
Your goal: Build a real numeric timestamp from explicit components, then reject values that normalize to a different date or clock time.
Full task requirements
Fill B2:B5 with a numeric Excel timestamp for exact YYYY-MM-DD HH:MM text from years 2000 through 2099. Preserve blank inputs as blank text. Return Review for every malformed, invalid or out-of-range input. Interpret the text as a local clock reading with no timezone conversion.
Valid local clock readingsValidate the local timestamp in A2
Read the exact local date/time spelling. A checked timestamp remains numeric, including its time fraction.
| # | |
|---|---|
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 |
Step 1 of 4
Validate the local timestamp in A2
Rules for this step
Read exact YYYY-MM-DD HH:MM text. Validate the calendar date, year 2000–2099 and clock bounds, then choose DATE and TIME. The checked output shows the stored day number and time fraction. Keep the original spelling and local clock.