Pareshj already help me but its my mistake not to tell him the information on the cells
so basically our Clock out Clock in machine give us data on our excel
example
A1 = 07:58( ) 11:16( ) 12:14( ) 19:09( )
Sometimes
A1 = 07:58( ) 11:16( ) 12:14( )
Sometimes
A1 = 07:58( ) 11:16( )
Sometimes
A1 = 07:58( )
the data means ... 07:58( ) 11:16( ) 12:14( ) 19:09( )
the first data is the clock in, then followed by clock out then clock in then clock out..
so basically
7:58 to 11:16 he made 3:18 hours
then on 11:16 -12:14 is BREAK/LUNCH
12:14 to 19:09 he made 6:55
overall he made = 10:13
is there a way to compute that on excel like a once cell formula or something? pls help
Bookmarks