Hello Maurice,

This formula will return the hours difference only.

=ABS((VALUE(LEFT(A1, 4)) - VALUE(RIGHT(A1, 4)))/100)

This will works as long as the format is 4 numbers either side of the
hyphen.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=374055