ExcelBanter - calculating time difference

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - calculating time difference (https://www.excelbanter.com/excel-worksheet-functions/175134-calculating-time-difference.html)

Michel Khennafi

calculating time difference

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

Teethless mama

calculating time difference

=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

All times are GMT +1. The time now is 04:59 AM.