Calculation 2 datetime in hours

[suzel404]

Hi,

ID, STARTDATE, ENDDATE   

1	30/10/17 18:59:00	31/10/2017  10:30:00
2	30/10/17 19:16:00	31/10/2017  12:00:00

I want to calculate the delay in hours from startdate and enddate.

INTERVAL(DATE(DATE#(ENDDATE, 'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') - DATE(DATE#(STARTDATE, 'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'), 'H') does not work.

Regards,

[swuehl · Accepted solution]

Your start dates show only two year digits, hence your format code should show only two 'YY'.

Also check that there are no additional spaces etc. in your field values that are not part of your format code.

Besides that, you don't need to format the dates using Date() function, when you want to format the result of the subtraction using Interval().

[suzel404]

Thanks,

I'll check !