1 is for full day & .5 for half day.
But copied the formula in wrong way.
For better understanding u can get it with evaluate option.
Let me know if still any assistance is required.
Sorry to ask you again, if INTIME is after 2.00 then show 0 and if in time and out time is blank or zero should show zero. please make it into same formula.
Dear Sir,
Sorry It didnt work, can you please look into the attached file.
I want result in yellow highlighted cell,system is calculating 2 clock = 14 please do accordingly and thanks a lot for your help.
Dear Sir,
Thanks for your help and sorry for disturb you, I found the problem is that system generated report is considering the time I need to do text to column once I do text to column formula works or I have to press F2 on each column.
Please let me know if there is any solutions for this. because it will take hrs to do text to column and F2 as well.