View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jmj713 jmj713 is offline
external usenet poster
 
Posts: 57
Default 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?