Date and Time 2021.xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 2021-05-07 11:31:37 +0800 | 7-May-21 | 11:31:37 | ||
2 | custom format d"/"m | 7/5 | |||
3 | custom format hh:mm | 11:30 | |||
4 | |||||
5 | 2021-05-07 21:41:37 +0800 | 7/5 | 09:45 PM | ||
6 | |||||
10c |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1 | C1 | =--MID(A1,12,8) |
B1,B5 | B1 | =--LEFT(A1,10) |
B2 | B2 | =B1 |
C3 | C3 | =MROUND(C1,"0:15") |
C5 | C5 | =MROUND(--MID(A5,12,8),"0:15") |
Date and Time 2021.xlsm | ||||
---|---|---|---|---|
A | B | |||
1 | 2021-05-07 11:31:37 +0800 | 7/5 11:30 AM | ||
10c |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | B1 | =MROUND(--LEFT(A1,19),"0:15") |