Forum Discussion
Llamaface06
Feb 17, 2026Copper Contributor
Time sheet for hours worked
I am needing to make a sheet that shows clocking in for work - clocking out for lunch - clocking in from lunch - clocking out for the day and then the total of those hours worked per day and then gra...
Lorenzo
Feb 17, 2026Silver Contributor
Hi
Your example gives 7.65 hours and you seem to want 7.6
==> That could be a round Down to the 1st digit
what do you expect for the other above examples?
mathetes
Feb 18, 2026Gold Contributor
Llamaface06 Let me add to the question Lorenzo asked:
Your example gives 7.65 hours and you seem to want 7.6
==> That could be a round Down to the 1st digit
And why round down in a borderline case, as opposed to rounding up? Are there potential employee relations implications, given that pay is affected, even if minimally?