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

[Guest]

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

 

[RagDyer]

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!
==============================================

 

[Guest]

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

 

[Ron Rosenfeld]

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)+(StartTime>EndTime)

Format the result as h:mm


--ron