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

R

rafi

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

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

Mike Punko

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
 
R

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
Click to expand...


=(EndTime-StartTime)+(StartTime>EndTime)

Format the result as h:mm


--ron
 
Top