Calculating hours and minutes between two dates

[R2D2]

Hi !

I know this has been here before, but I cannot find that message any more... Sorry..

The problem is how to calculate simple way hours and minutes between two dates for example:

date1, time1

date2, time2

Thanks in advance !

Arttu Lahdenper

[CobaltSky]

Hi Arttu,

Here is a formula that will suit the purpose you've described:

time2 - time1 + (date2 - date1) * 86400

You will need to ensure that the calculation result is specified as time.

[R2D2]

Thank you !

That's just what I was looking for.

Arttu