number of days

[srinivasa1]

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

[krishnacbe]

Hi

Hope below expression help to solve your issue.

=Timestamp( enddatetime -startdateand time , 'hh')

Regards

Krishna.

[krishnacbe]

Hi

To display the difference in Day. Use below expression.

=Timestamp( enddatetime -startdateand time , 'd')

Regards

Krishna

[Gysbert_Wassenaar · Accepted solution]

try: interval(enddatetime -startdatetime,'D')

if you want to see the difference in days and hours+minutes use 'D - h:mm'

[srinivasa1]

Thanks.