As regards Multiplying time values and numbers
lelissimo wrote on November 02, 2005 05:33 EST |
Hi
I've tried to calculate the payment as displayed in the tip, but think there must be a mistake :confused:
I've put worked hours in column C:C, rates in column D:D and calculated payments in column E:E using "=C2*D2*24" formula, but the result is obviously very different from yours! :
Hours___Rate____Payment
22:00___$20_____440
14:00___$25_____350
27:00___$30_____810
How comes? |
As regards Multiplying time values and numbers
lelissimo wrote on November 02, 2005 05:35 EST |
Hi
I've tried to calculate the payment as displayed in the tip, but think there must be a mistake :confused:
I've put worked hours in column C:C, rates in column D:D and calculated payments in column E:E using "=C2*D2*24" formula, but the result is obviously very different from yours! :
Hours___Rate____Payment
22:00___$20_____10560
14:00___$25_____8400
27:00___$30_____19440
How comes? |
Time format?
Weezy1957 wrote on November 02, 2005 07:39 EST |
| Did you format the cells to a Time type? I did this and it works perfect. |
Steps in Multiplying time values and numbers
Anita Henley wrote on December 31, 1969 19:00 EST |
"Multiplying
Time Values and Numbers"
Hours Rate Payment
22 $20 $440.00
14 $25 $350.00
27 $30 $810.00
Please explain why you multiplied by 24. When you multiply the hours by the rate you calculate the payment.
22 $20 $10,560
14 $25 $8,400
27 $30 $19,440
my e-mai is
anita.henley@sprint.com |
No enough explaination to justify formula
Tom wrote on December 31, 1969 19:00 EST |
| There is no way your formula will result in the answers you have show in your example! |
Some Tip Clarification
MdniteCreepr wrote on November 02, 2005 09:06 EST |
This tip starts out referencing columns C and D which contain time and rate data, then the demonstration formula references columns A and B. I would think this could be very confusing. Someone not so familiar with Excel would attempt to recreate the tip step by step, and end up very frustrated. This is probably just me being picky, but when I'm mentoring co-workers in Excel, I make sure I'm consistent in my references to avoid confusion.
It might also be useful to users to explain why certain formats act as they do. For instance, in this tip, why must Hours x Rate be multiplied by 24? Excel treats time formats quite differently than regular numbers. One day = one whole time unit, therefore one hour = 1/24th of a whole unit, and we must multiply hours by 24 to achieve whole units of time. |
More explanation, please
Confused wrote on December 31, 1969 19:00 EST |
Could you give a brief explanation of the time format used, and its significance in calculations? Or, how about pointing out where this info can be found, and why it is beneficial. It seems easier to just use a number format, say the person worked 22 hrs, and do a simple multiplication to get the payment!
Thanks! |
Good Site but improve standard
Siddhanta Goel wrote on December 31, 1969 19:00 EST |
This is a very good site but pls improve the std. of tips...
Best Wishes,
Siddhanta Goel |
Clearly this doesn't work...
Matt Day wrote on December 31, 1969 19:00 EST |
omg...
God bless the internet eh?
Trying to multiply 3 hours, 33 minutes and 20 seconds by the integer 55. The result is 13:20:00
ya... |
Financial Reporting and Analysis (2nd Edition)
