sum of hours
hi, i am currently working on my staff’s offset hours which is 6hours overtime=1 day off. i think i’ve done well on other formula, however upon adding all overtime hours, the total hour is different from how you normally (manually) compute it. kindly give your insights.
OT2:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:003:00Total 125:00
in the total cell i just used normal sum function. it is supposedly 53 hours of overtime. but it keeps showing 125 hours. i’ve tried the [h]:mm formatting but doesn’t work.
hi, i am currently working on my staff’s offset hours which is 6hours overtime=1 day off. i think i’ve done well on other formula, however upon adding all overtime hours, the total hour is different from how you normally (manually) compute it. kindly give your insights.OT2:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:002:003:00Total 125:00 in the total cell i just used normal sum function. it is supposedly 53 hours of overtime. but it keeps showing 125 hours. i’ve tried the [h]:mm formatting but doesn’t work. Read More