Subtracting Cells formatted with Date AND Time to get hours?

  • Thread starter mcr1 - ExcelForums.com
  • Start date
M

mcr1 - ExcelForums.com

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

mcr
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top