I am trying to figure out how to subtract one time from the other to
find out the number of hours/minutes passed between times.
For example
A B
1 09:00 11:30
I would like cell C1 to tell me 2.5 hours or 2:30 (whatever format it
comes out). I will be listing a bunch of these times, so then at the
end I would also like to SUM the C column and it give me the total
hours spent. Kinda like a time log.
Thanks geniuses.
--
killertofu
------------------------------------------------------------------------
killertofu's Profile:
http://www.excelforum.com/member.php...o&userid=31024
View this thread:
http://www.excelforum.com/showthread...hreadid=512881