View Single Post
  #1   Report Post  
mcr1 - ExcelForums.com
 
Posts: n/a
Default Subtracting Cells formatted with Date AND Time to get hours?

Thanks in advance for the help. Is it possible to subtract 2 cells
that are both formatted as mm/dd/yyyy h:mm to just have it subtract
the times to get a total # of hours between the 2. For example, A1
is 1/1/05 13:00 and B1 is 1/2/05 14:30. I'd like C1 to give me the
total of 25:30. This forum is always a great place for help. Thanks
again in advance for your help.

mcr1