Thanks, Arvi !
(I multiplied the results returned
by 24*60 to convert it to numbers)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Arvi Laanemets" wrote in message
...
Hi


=TIME(LEFT(B2,2),MID(B2,3,2),0)-TIME(LEFT(A2,2),MID(A2,3,2),0)+(TIME(LEFT(B2
,2),MID(B2,3,2),0)<TIME(LEFT(A2,2),MID(A2,3,2),0))


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )