calculating time difference

M

Michel Khennafi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to calculate difference between two date & time along with working hours and days 2
separating date and time 5
End Date/Time adding business hours 1
Calculate elapsed time excluding specific timeframe 10
Time Zone Conversion Table 1
Checking for date and time overlaps 0
Determine "on time" status 9
compute date and time difference 5

Top