View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Vincent Steve Vincent is offline
external usenet poster
 
Posts: 32
Default Difference between dates/times in Days & Hours

Hi,

I need to calculate the difference between two dates/times. The date/time
is entered in this format:

12/12/07 3:52 PM

When I simply subtract the end date from the start date, it gives me a
number in days with two-digit decimal place for partial day (e.g., 5.01). Is
there a way to format the cell or add to my simple formula (=B2-A2) to
convert the number into days/hours/minutes of some kind? I've been
experimenting without much luck, and didn't see a posting that was specific
to this issue.

Thank you in advance,
Steve