I think you must enter the full date & time for each of these and make
sure they are formatted as "Time". Assuming that these two times are
in cells A1 & B1, in C1 (formatted as number) enter the formula:
"=(B1-A1)*24". This will give you the hours in decimal form (in this
case 2.62 hrs). If you want it in minutes then the formula is:
"=(B1-A1)*24*60" (this = 157 minutes).


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=471757