Duration between two dates

[Anonymous]

Hi All,

I have two dates and require the duration between these dates in hours and minutes, can anyone help as to how this is done?

ID	Arrived	Departed
1	01-01-2018 10:00:00	05-01-2018 09:15:00

I would like to show for the above the numbers of hours and minutes between product arriving and then departing the warehouse.

If this is not possible just getting the numbers of days would work.

Thanks

[YoussefBelloum]

Hi,

try this:

=Interval(Timestamp#(Departed,'DD-MM-YYYY hh:mm:ss')-timestamp#(Arrived,'DD-MM-YYYY hh:mm:ss'),'HH MM')

it will give you 95 hours and 00 minutes

[undergrinder]

Hi Raman,

=Interval(Arrived,Departed,'hh:mm:ss')

G.