I’m trying to create a time sheet for employees hours with breaks and a weekly/monthly total. For example I have the clock out time 5:00 - clock in time 8:00 and the break entered as 30m. All good there.
The problem comes in when I try to get a total sum when a break has been calculated. I get “Values being summed by SUM must either be all durations or all numbers, unless one value is a date”
MacBook Pro 13″, macOS 15.3
Hi Archetype-Nexus,
Archetype-Nexus wrote:
The problem comes in when I try to get a total sum when a break has been calculated. I get “Values being summed by SUM must either be all durations or all numbers, unless one value is a date”
I do not understand "when a break has been calculated." Please tell us how a break is calculated. Or, is manually entered?
For example,
Format of Column B is Date & Time (Date not displayed).
Format of Column C is Duration (typed in).
Format of Column D is Date & Time (Date not displayed).
Format of Column E is Duration (calculated with the formula D2−C2−B2)
Or are you doing something differently?
Regards,
Ian.
employees hours with breaks and a weekly/monthly total.
