no output in time when i use lookup

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Click on "Reply" ...

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

trying to upload file

Originally Posted by JohnTopley

Click on "Reply" ...

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks sir i already deleted the picture and i upload my file thank you so much

In F2

=TIME(HOUR(D2),0,0)

copy down

and what is VLOOKUP in H for ???

Is H2 ..

=G2-F2

???

Originally Posted by JohnTopley

In F2

=TIME(HOUR(D2),0,0)

copy down

and what is VLOOKUP in H for ???

Is H2 ..

=G2-F2

???

yes sir H is for Total of time - 1 ( for lunch time)

sir can i ask what is the ,0,0 in the formula of =TIME(HOUR(D2),0,0)

=TIME(HOUR(D2),0,0)

0,0, is the minutes, seconds

Originally Posted by JohnTopley

=TIME(HOUR(D2),0,0)

0,0, is the minutes, seconds

Sir another problem
about H =G2-f2

my time in was 7:00 AM
my time out was 8:00 AM
But the result is 0.04
i want the result is 23 hours is it possible to cumpute ?? o

Why would the answer be 23? Only 1 hour was worked?

Originally Posted by DannyJ

Why would the answer be 23? Only 1 hour was worked?

example sir. she/he time in at 8:00 AM (january 1,2017)
time out at 5:00 AM (January 2,2017)

the formula will compute the total of hours worked.

in H2

=G2-F2+(IF(G2<F2,1))

format as [h]:mm

However, you will need DATE and TIME if people work more than 24 hours.

08:00 start (21/06/2017) 09:00 finish (22/06/2017) = 25 hours

the above formula will return 1:00 for the above.

John's solution is better