Dear Communit, Need help!! How i can get ...

(Abu Md. Moniruzjaman) #1

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

(Suvrutt Gurjar) #2

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.