# 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

overall he made = 10:13

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

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

i got it already...
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?

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1