| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating difference in time | Excel Discussion (Misc queries) | |||
| Calculating time difference then rounding down | Excel Discussion (Misc queries) | |||
| Calculating time difference in minutes | Excel Worksheet Functions | |||
| Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
| Calculating time difference | Excel Discussion (Misc queries) | |||
Linear Mode
