Days between and charge rate calc

Have a spreadsheet setup to record the days between charge of a watch (or anything), and the charge rate, when charging.

  • In the sample, hours column is [this day - previous day]*24 + [this time - last time] (sort of)
  • AND Rate is [FullCharge% - LastCharge%]/[FullHours - EmptyHours]

Should be a fairly simple thing? Just not for me…
Clues?
Thanks.
Sample…

Why an image in the attachment and not a Calc file?

1 Like

Charge.odb (13.8 KB)