Time in and out with Check mark to check out

Good morning

I was wonder if anyone can help me solve a formula error I scan a Id in colum A3 using this code in colum B3 =IF(A3="","",IF(LEN(A3)>6,VALUE(LEFT(A3,LEN(A3)-1)),A3))

then the name appears and the time shows in colum D3 using this code =IF(B3<>"",IF(D3="",NOW(),D3),"") and in colum E I have a check mark then it shows the output time in colum F using this formula =IF(B3<>"",IF(E3=TRUE,IF(F3="",NOW(),F3),""),"") Here is where I am having a error I want to know the difference between colum D3 and colum F3 in colum G3 showing the results after the check mark in colum E I have this formula In colum G =TEXT(F3-D3, "h:mm:ss") It works fine just when I copy the rest of the formula down the colum gives me a #value error but after using the check mark it shows the difference in time and disapears I just want to make it so it dont show the #value error.

I think I have to use a =if function I am new to excel and I am not sure what I am doing wrong in colum G3 so when I copy the formula down it dont show me the #value error

Here is a pic of the excel file

2019-09-20-085756.png

Link: https://i.ibb.co/DpkxrMh/2019-09-20-085756.png

Good day
This forum has helped me alot. I have another question I orginally wanted to do the check box option for when the task is completed but now that I know that I have to manually formate each cell and link it to another cell I prefer to change it to a drop down menu in E3 just saying header completed then Yes or no and if yes is selected it shows the difference in time but I have no clue how to set up the drop down menu and formate it to 1000 cells?? any help I have a example pic above in the previous post.

Or is it possible to extend the check marks without having to format control all of them to each cell manually? I need the check marks in 1000 cells. Everytime I try to drag the check marks down to copy to the other cells it does go down and shows them but when I check one of them it checks all of the new cells including the cell I copied it from..

As this is going to require some action be taken in a cell, I would suggest that you select the appropriate cell in column F and hold the Ctrl and Shift keys while pressing the ; key, which will time stamp the cell in column F.
If it is important that the corresponding cell in column E show something (as in "Yes") then use: =IF(F3<>"","Yes","")
If you would like to see this applied to you spreadsheet please upload the sample from which the screenshot is taken by clicking the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.