我想寫以下公式, 除了用IF 外, 請問還可以用什麼公式取替呢?
1min - 45min =0.5
46min-1hr15min=1
1hr16min-1hr45min=1.5
1hr46min-2hr15min=2
2hr16min-2hr45min=2.5
2hr46min-3hr15min=3
...
...
如此類推,去到=10
收錄日期: 2021-04-15 19:30:40
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080629000051KK00203