# Help me guys.. (problem with computing Hours of Work)

1. ## Help me guys.. (problem with computing Hours of Work)

Our ID scanner send us data like this on excel

A1 = 07:50( ) 11:33( ) 12:22( ) 19:02( )

sometimes

A2 = 12:22( ) 17:00( )

i cant solve how to get total hours work in once cell pls help

2. ## Re: Help me guys.. (problem with computing Hours of Work)

try to extract first in time and last out time and then use =+TEXT(VALUE(value1)-VALUE(value2),"HH:mm")

3. ## Re: Help me guys.. (problem with computing Hours of Work)

what do you mean extract .. put it on other column? if its correct icant do that thats too many

4. ## Re: Help me guys.. (problem with computing Hours of Work)

Hi pamboys009,

You can use the below formula :

=TEXT(MID(RIGHT(A2,8),1,5)-LEFT(A2,5),"HH:MM:SS")

Where A2 is the Input cell (i.e 07:50( ) 11:33( ) 12:22( ) 19:02( ) OR 12:22( ) 17:00( ) )

Regards,
Paresh J

5. ## Re: Help me guys.. (problem with computing Hours of Work)

wow your the best.. ill study how you do the formula! THANKS!

anyway second question... IF the input cell is blank like the employee didnt go to work.. the result is a #VALUE!
how can i just put 0:00:00 if theres error?

6. ## Re: Help me guys.. (problem with computing Hours of Work)

Hi pamboys009,

Dont forget to Click * Add Reputation and Mark this thread as Solved.

Regards,
Paresh J

7. ## Re: Help me guys.. (problem with computing Hours of Work)

Thanks i already add reputation... i have a followup question mr pareshj

8. ## Re: Help me guys.. (problem with computing Hours of Work)

Hi,

Regards,
Paresh J

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