Time log / cost statement guide

Turn time logs into a checkable cost statement

Keep elapsed seconds, excluded time, hourly rate, and rounding unit/rule on the same row before checking the total.

Separate four conditions

The synthetic formula is billable seconds × hourly rate ÷ 3,600. Keep both raw and excluded seconds before rounding.

ConditionValue to checkExample
Elapsed timeRaw seconds3,661 seconds
Excluded timeSeconds left out61 seconds
Hourly rateAmount per hour¥2,500
RoundingUnit and rule¥100, nearest

Follow seconds to amount

Do not round to one hour before applying the rate. First establish billable seconds, calculate the raw amount, then apply the stated unit and rule.

3,661 sec − 61 sec
= 3,600 billable sec
× ¥2,500 ÷ 3,600
= ¥2,500
Separate excluded time first.
1 sec × ¥100,000 ÷ 3,600
= ¥27.77...
¥1 unit, round up
= ¥28
Apply rounding after the calculation.

Handoff fields

Pass raw seconds, excluded seconds, billable seconds, rate, rounding condition, and amount on the same row. Do not hand off only the total.

case: excluded-half-hour
raw: 1,801 seconds
excluded: 1 second
billable: 1,800 seconds
rate / rounding: ¥3,000 / ¥100 down
amount: ¥1,500

The fixtures are static. They do not fetch or send Stopwatch history or user input.

What this guide does not guarantee

It is not an invoice, tax or currency calculation, contract or accounting advice, legal payment obligation, or proof of a live Stopwatch record. Verify real data in the existing time-cost tool.