# Another Question Guys about computing total HOURS

1. ## Another Question Guys about computing total HOURS

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

is there a way to compute that on excel like a once cell formula or something? pls help   Register To Reply

2. ## Re: Another Question Guys about computing total HOURS

with the formula =TEXT(MID(RIGHT(E5,26),1,5)-LEFT(E5,5)+MID(RIGHT(E5,8),1,5)-MID(RIGHT(E5,17),1,5),"HH:MM:SS")

second question guys... how can i remove the #VALUE! error when theres no value on a cell??
example if A1 doesnt have any my formula will give me #value! error is there a way it will GIVE 00:00:00 if theres a value error?  Register To Reply