=B1-A1 and format as [hh]:mm

--
HTH

Bob Phillips

"mcr1 - ExcelForums.com" wrote in
message ...
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