| Time String | Formula | Excel TimeStamp | Formatted TimeStamp |
|---|---|---|---|
| 3:15 | =TIMEVALUE(A1) | =TIMEVALUE(A1) | =B1 |
| 13:15 | =TIMEVALUE(A2) | =TIMEVALUE(A2) | =B2 |
| 15:15:15 | =TIMEVALUE(A3) | =TIMEVALUE(A3) | =B3 |
| 3:15 AM | =TIMEVALUE(A4) | =TIMEVALUE(A4) | =B4 |
| 3:15 PM | =TIMEVALUE(A5) | =TIMEVALUE(A5) | =B5 |
| 5PM | =TIMEVALUE(A6) | =TIMEVALUE(A6) | =B6 |
| 9:15AM | =TIMEVALUE(A7) | =TIMEVALUE(A7) | =B7 |
| 13:15AM | =TIMEVALUE(A8) | =TIMEVALUE(A8) | =B8 |