Xiaopei's DokuWiki

These are the good times in your life,
so put on a smile and it'll be alright

User Tools

Site Tools


it:iwork

iwork

numbers

| 8/31/2012 8:54:22 AM | -> | 8/31/2012 | 8:54:22 |

ABC
8/31/2012 8:54:22 AM=LEFT(A,FIND(“ ”,A)-1)
  1. =RIGHT(A,LEN(A)-FIND(" ",A)+1)
  2. Copy & Paste Value
  3. modify Cell Format in Inspector
8/31/2012 8:54:22 AM8/31/20128:54

做图表时, Y轴好像不能为 Time 类型, 所以 8:54 需转为 8.54 (但分位进制又不对)

it/iwork.txt · Last modified: 2013/08/19 07:22 (external edit)