| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the formula to calculate electricity consumption
You've been told in another thread that Excel times are in whole days, and
hence you what the conversion is between Excel times and hours. -- David Biddulph "TSK" wrote in message ... 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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the formula to calculate electricity consumption
David,
I share your irritation concerning multiple posts but in this case the only similar one I can see is this unanswered one from yesterday. Where is the duplicate? http://www.microsoft.com/office/comm...0-676bf991bfc5 Mike "David Biddulph" wrote: You've been told in another thread that Excel times are in whole days, and hence you what the conversion is between Excel times and hours. -- David Biddulph "TSK" wrote in message ... 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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the formula to calculate electricity consumption
I didn't say it was a duplicate.
The other message where we'd discussed the relationship betwen Excel time and hours was: -- David Biddulph "Mike H" wrote in message ... David, I share your irritation concerning multiple posts but in this case the only similar one I can see is this unanswered one from yesterday. Where is the duplicate? http://www.microsoft.com/office/comm...0-676bf991bfc5 Mike "David Biddulph" wrote: You've been told in another thread that Excel times are in whole days, and hence you what the conversion is between Excel times and hours. -- David Biddulph "TSK" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the formula to calculate time & power consumption | Excel Discussion (Misc queries) | |||
| I need a template to record my daily electricity usage | Excel Discussion (Misc queries) | |||
| Fule consumption | Excel Discussion (Misc queries) | |||
| how do i create a four line consumption schedule for economics | Charts and Charting in Excel | |||
| Consumption function | Excel Discussion (Misc queries) | |||
Linear Mode
