=A2-A1

Format cell as: [h]:mm


"Michel Khennafi" wrote:

Good morning

Thanks for looking at this post.

I have a situation where I need to determine a variance between 2 cells
where time is stored.

Cell 1 (expected delivery date) = 1/1/2008 10:00:00 AM
Cell 2 (real delivery date)= 1/2/2008 11:00 AM

I would like to obtain the difference expressed in day or in hours in a cell
3. Any idea about this one?

Thanks