I interpret this as the total produced and not the rate. So, the residence produced 2kW per minute to achieve the ~120kWh?
120 kWh ÷ 60 minutes = 2 kWm
2kWm ÷ 240V = 8.3 Am (using Pf = 1)
Am I thinking of this correctly?
Thinking about minutes is distracting you from the meaning of these terms.
There is already a time unit in the denominator of kilowatts, since Watts means Joules/second. Inserting another time unit downstairs (e.g. kW/hour, kW/minute, kW/sec) would mean the ramp rate of power, a term that is related to power in the same way as acceleration is related to speed.
Kilowatt-hours means kilowatts multiplied by hours. Given 120 kW-hrs in 1 hour, this means 120 kW-hr / (1 hour) = 120 kW for the average power associated with this time interval. Assuming it is constant, this means we want 240V * Unknown Amps to equal 120,000 Watts. Solve for the unknown amps, and get 500A.
Since this is unrealistic for an individual residence, I suspect that there is more to the spreadsheet that might give some context. Maybe the column refers to kW-hrs on each hourly meter reading, and you'd have to subtract the previous reading to get the kW-hrs you care about.
Another possible explanation is that the current transformer ratio is incorrectly configured inside the meter, assuming it is the type of meter that uses CT's.