Thread: What is the formula to calculate electricity consumption
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TSK TSK is offline
external usenet poster
  
Posts: 21
Default What is the formula to calculate electricity consumption
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)
Reply With QuoteReply With Quote