How to exclude specific hours form total sum hour

[karamaianguy]

Helo Expert,.

2 sample with different 'sum' issue.

[gak67]

Try format [h]:mm for the first issue.

Try this formula for the second:

Please Login or Register  to view this content.

[jewelsharma]

See attached.Table_sum matter2.xlsx
Hope that is what you wanted.

[karamaianguy]

Well done !!!

gak67
jewelsharma

Thanks a lot,.

[gak67]

My formula would not work if the break down period was all before 12:00 or all after 13:00. This should work in all situations:

Please Login or Register  to view this content.

[karamaianguy]

Helo gak67,.
I just realize on the my real table the earier function not work propely.
But the latest one works very accurate.

Thanks a lot,.
Cheers

[karamaianguy]

Helo gak67,.
I just realize on my real table the earier function not work propely.
But the latest one works very accurate.

Thanks a lot,.
Cheers