Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How i can calculate day from time diffrence like( enddatetime -startdateand time) if its duration is 50 hrs then it will be 2 days .pls help
thanks
try: interval(enddatetime -startdatetime,'D')
if you want to see the difference in days and hours+minutes use 'D - h:mm'
Hi
Hope below expression help to solve your issue.
=Timestamp( enddatetime -startdateand time , 'hh')
Regards
Krishna.
Hi
To display the difference in Day. Use below expression.
=Timestamp( enddatetime -startdateand time , 'd')
Regards
Krishna
try: interval(enddatetime -startdatetime,'D')
if you want to see the difference in days and hours+minutes use 'D - h:mm'
Thanks.