To get Total Hour & Late Hour from Time In, Time Out, 1st Break & 2nd Break

Transact-SQL
22

Hi Sir,

Yes. This is correct.

Regards,
Micheale

23

Hi Sir,

Sorry. I don't understand. Can you used my example to write a skeleton sql statement that produce the result shown above? Appreciate for your kind help & expertise. God bless you richly.

Thanks.

Regards,
Micheale

24

hi micnie

i had the idea in my head .. to make it very simple ..

When i tried to implement .. all kinds of stumbling blocks ..

I will NOT be able to implement my idea ..

Sorry ..