| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference between dates and times
I'm having real trouble coming up with a formula to get a difference between
two cells which contain full dates and times. If I have 2/2/09 8:00 AM in A1 and 4/2/09 12:10 PM in B2, in the third cell I entered =B1-A1 and formatted the cell as Custom and Type: d "days" hh "hours" mm "minutes" - but I'm not getting the right number of days. The output says: 28 days 04 hours 10 minutes, so the hours and minutes is correct, but not the days. How can I fix this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating difference between times on 2 dates | Excel Worksheet Functions | |||
| Calculating the difference between 2 dates and times | Excel Discussion (Misc queries) | |||
| Need difference between two dates/times in hours | Excel Worksheet Functions | |||
| Difference in dates calculations except between certain times. | Excel Discussion (Misc queries) | |||
| Difference between 2 times and dates | Excel Worksheet Functions | |||
Threaded Mode
