View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michel Khennafi Michel Khennafi is offline
external usenet poster
 
Posts: 10
Default 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