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
|