Forum Discussion

Llamaface06's avatar
Llamaface06
Copper Contributor
Feb 17, 2026

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...
excel
Formulas and Functions
Llamaface06's avatar
Llamaface06
Copper Contributor
Feb 17, 2026

Sorry - wasn't sure how to word everything. So we round the total hours worked for each day to the nearest tenth of an hour. Here is an example -

Clocked in 8:00AM

Lunch out 12:00PM

Lunch in 1:21PM

Clocked out 5:00PM

Totals to 7.6

I am hoping there is a formula for excel that will give me that exact answer. Thank you :)

Lorenzo's avatar
Lorenzo
Silver Contributor
Feb 17, 2026

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's avatar
    mathetes
    Gold Contributor
    Feb 18, 2026

    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?