Verifying data by putting True or False

Hi everyone..

Can anyone help me with my problem..

What I would like to happen is True should appear on the Verification column if the data in Att_time is true and if the data is not true, False will appear.

Att_time is the total number of hours worked by an employee based on their clock in and clock out.

Thank you in advance for helping.

Attach is the sample sheet. samplesheet.xlsx

It doesn't work based on the requirements I've given.

Originally Posted by FDibbins

That doesnt exactly help too much Perhaps your requirements where not explained to clearly?

try this, copied down...
=IF(F4=1-D4+E4,TRUE,FALSE)

or justthis...
=F4=1-D4+E4

Hi.. True or False appears.. but the problem is.. even if the data in the Att_time column is true, false is the one appearing..

Originally Posted by FDibbins

Can you tell me where it is not performing as expected?

	D	E	F	G
1	Clock In	Clock Out	ATT_Time	Verification
2
3
4	18:44	06:37	11:53	TRUE
5	19:28	06:42	11:13	FALSE
6	19:39	06:30	10:50	FALSE
7	20:54	06:18	09:23	FALSE
8	19:48	06:23	10:34	FALSE
9				#VALUE!
10				#VALUE!
11	20:40	06:37	09:56	FALSE
12	21:07	06:42	09:35	FALSE
13	19:26	06:30	11:03	FALSE
14	21:10	06:18	09:08	FALSE
15	15:23	06:23	15:00	TRUE

Thanks.. Would it be possible if I add another column beside Att_time, Double Checking Column.

And in the double checking column, the total number of hours worked based on the clock in and clock out will be computed.

Then the data from the Att_time and Double checking column will be compared by putting true or false in the Verification column.

True if the data for both columns are the same. If there is a slight difference of 00:01, still true.

False if the difference is 00:02 and greater.

Would that be possible? Thanks for helping.

11.jpg

Attach is the sample screenshot.