What is the formula to calculate electricity consumption
Try this in a3
=(A1*24)*A2
Mike
"TSK" wrote:
Time required - 1:30 (Cell A)
Assuming 1.5KwH (Cell B)
Cell A1 - 1:30 (Time format)
Cell A2 - 1.5Kwh (Number format)
Cell A3 - A1*A2 (I need the answer to be 2.25KwH)
|