BENRI / GUIDES
Calculate work hours separately from breaks
Organize office, remote and break intervals to check working time, including days with a lunch break or a personal outing.
Separate elapsed time from working time
09:00 to 18:00 spans nine hours. With a one-hour lunch break, the working total is eight hours. Write down the non-working intervals as well as the start and finish.
If you move from the office to remote work, record that change separately from lunch so the day’s timeline remains clear.
Choose a daily check or a longer record
Notes and a calculator can handle a simple day. A spreadsheet suits multiple days and custom totals. BENRI Work Hours Calculator is useful when you want to see one day’s activity intervals and breakdown together.
Scroll horizontally to compare →
Compare methods for your task| Method | Useful for | What to consider |
|---|
| BENRI Work Hours Calculator | Calculate actual work from start, finish and break times | Compare activity intervals on the timeline |
|---|
| Notes and calculator | A quick daily calculation | Retain the original times and breaks |
|---|
| LibreOffice Calc | A table covering many days | Define the formulas and categories you need |
|---|
BENRI Work Hours Calculator: Enter work, breaks and personal time
- Enter the workday’s start and finish.
- Add office, remote-work, break or personal-absence intervals.
- Check the timeline for gaps or overlaps in the entered intervals.
- Read the total and breakdown when checking a daily report or planning the rest of the day.
For example, enter office work from 09:00–13:30, remote work from 13:30–18:00 and lunch from 12:00–13:00. The timeline makes the overlap visible even when the break falls inside an office-work interval.
Enter start, finish and break times to check the working-time total. (Japanese interface.)BENRI Work Hours Calculator: calculate working time ↗
Notes and a calculator: subtract minutes
- Write down the start, finish and break times.
- Convert 09:00–18:00 to 540 minutes and subtract a 60-minute break.
- Divide the remaining 480 minutes by 60 to get eight hours. Subtract personal absences in the same way.
Useful for a simple day. Keep the intervals beside the total when there are several breaks.
LibreOffice Calc: calculate several days
- Put start, end and break duration in columns A, B and C; for example 09:00, 18:00 and 01:00.
- Enter =B2-A2-C2 in D2 and format it as [HH]:MM. The example returns 08:00.
- Add rows for other days, copy the formula and use SUM for a total.
Useful for several days. This example is within one day; include dates with the start and end values for overnight work.
Open the official instructions
Handle a mid-day outing the same way
If a 09:00–18:00 day includes one hour of lunch and 30 minutes of personal time, and both are excluded from work, the working total is seven hours and 30 minutes.
The intervals show what was excluded. Check the category behind each label, especially when using custom names, so the breakdown reflects the intended work and non-work periods.
Use the breakdown in the daily record
Read the total and activity breakdown when preparing a daily report or considering how much work remains until a planned finish time.
For an attendance submission, transfer the figures according to the workplace’s classification and recording rules.
