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
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
try to extract first in time and last out time and then use =+TEXT(VALUE(value1)-VALUE(value2),"HH:mm")
what do you mean extract .. put it on other column? if its correct icant do that thats too many
Last edited by pamboys009; 06-27-2014 at 02:22 AM.
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
Click on "* Add Reputation" as a way to say thanks
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?
Last edited by pamboys009; 06-27-2014 at 02:29 AM.
Hi pamboys009,
Glad to help.
Dont forget to Click * Add Reputation and Mark this thread as Solved.
Regards,
Paresh J
Thanks i already add reputation... i have a followup question mr pareshj
Hi,
For new question, create a new thread please.
Regards,
Paresh J
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks