With start time in A1,
And end time in B1,
Try this in C1:

=((B1-A1+(B1<A1))*24)*AND(B1<0,A1<0)

Make sure C1 is formatted to General or Number.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"rafi" <rafi @discussions.microsoft.com wrote in message
...
i just want to put the time a worker come and the time he go and to have
the
number of houers he worked