Hi Jan. Thanks for your message. No I haven’t encountered procoro software yet. Is it a project management tool in construction industry? Other than the tutorials in my youtube channel, I do advisory services for corporate clients too. I had a few clients in construction business too actually. We can set up a call to get to know each other better and see if there is any area we can work together.
胡Sir， Do you teach how to use procoro software ? Thanks
Hi Jan. Thanks for your message. No I haven’t encountered procoro software yet. Is it a project management tool in construction industry? Other than the tutorials in my youtube channel, I do advisory services for corporate clients too. I had a few clients in construction business too actually. We can set up a call to get to know each other better and see if there is any area we can work together.
Hi胡sir，=unique(範圍)，唔知點解我出的結果一直係#NAME?...
意外發現這個頻道！！！好讚！！！可是我不會廣東話...也沒有辦法開字幕...看不懂真的好可惜😢😢😢
影片將會陸續加入字幕的，多謝你的支持。👏🏻👏🏻
你好，我想問下點樣count時間？
第二課，日期相關函數課題中，有示範計算小時的。首先轉換左為小時，或需要的單位，再用SumIfs進行加總。
我係想計算唔好一日入邊有幾多個呢個時間出現？
@@hihioscarma851 我諗我明白你的意思。想數下有幾多個時間係某一時間，例如數下有幾多個10Am，係咪？
要用到MOD，用餘數計算。
係呀。就係咁啦。有冇辦法胡Sir😭😭
@@hihioscarma851 將所有時間，用=MOD(A1,1),計算餘數。咁就數到架啦。
例如，零晨12點，餘數將會係0，咁即係話，所有0就係代表住果個時間。
用文字比較難表達，希望你明白我的意思，你試試MOD函數先。