|Need a bit more info.|
1st shift 8AM to 5PM; what part is 2nd shift or 3rd shift.
I can guess the start time for 2nd shift is 5PM
but what are the other times?
How do you need it displayed?
Do you have a column/row that just shows Labor Hours
or some other configuration.
A small sample of what your spread sheet looks like would be helpful
If you wish to post an example, please read this HOW-TO
as it explains the use of the < PRE > tags to align you data so it looks correct.
my result needs to be Number.
You mean in a decimal format, not an hourly format, correct?