Dear Communit,
Need help!!
How i can get the real time in a column.
I hv 2 columns โlog outโ &
โreturn timeโ. In another column i get the โprobable real timeโ by this formula โ=IF(ISBLANK([เฆธเฆฎเงเฆญเฆพเฆฌเงเฆฏ เฆซเงเฆฐเฆพเฆฐ เฆธเฆฎเฆฏเฆผ]), โ000:00:00โ,[เฆธเฆฎเงเฆญเฆพเฆฌเงเฆฏ เฆซเงเฆฐเฆพเฆฐ เฆธเฆฎเฆฏเฆผ]-[เฆฌเฆนเฆฟเฆฐเฆพเฆเฆฎเฆจเงเฆฐ เฆธเฆฎเฆฏเฆผ])โ
It get me the static time duration ex 5:00:00 like this. But i want the โprobale real timeโ column will get me the current time. Say if โlog out timeโ (datetime) is 9/22/2018, 3:00:00 & Return time is 9/22/2018, 5:00:00.
My โprobable return timeโ will get me the actual real time remaing to return. It will always change by time untill the real time comes.
How to do so??
Any link/doc/formula??
Thnx in advance
Hi @Abu_Md_Moniruzjaman,As per my understanding if your Return time is set to 9/22/2018, 5:00:00 and current time is 9/22/2018, 3:30:00,then you would like to display 01:30:00 as probable return time.
One possible option is you may wish to have column calculate [Return Time]-Now() and update that column based on an action. You will need to tap that
action to get the latest real time remaining.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |