i want to calculate the houers of workers 21:00 - 05:00 =8
 

i just want to put the time a worker come and the time he go and to have the
number of houers he worked

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

A B C
1 Start End Duration
2 7:12 AM 4:30 PM 9:18

C2= B2-A1
Set Cell to hh:mm

Hope this helps

"rafi" wrote:

i just want to put the time a worker come and the time he go and to have the
number of houers he worked

On Tue, 27 Sep 2005 12:19:04 -0700, "rafi" <rafi @discussions.microsoft.com
wrote:

i just want to put the time a worker come and the time he go and to have the
number of houers he worked


=(EndTime-StartTime)+(StartTimeEndTime)

Format the result as h:mm


--ron