Converting time value to currency value
Posted by Sandana on December 21, 2001 8:32 PM
It looks simple and I'm totally stumped!
Cell A1 has a time value of 18:39:00.
(I've had to use hh:mm:ss so it would calculate past 24 hours) A1 is not an input cell but is calculated from a separate worksheet using the formula
=SUM(Sheet1!I51-"40:00:00"). This gives overtime hours.
My formulas are as follows:
A1 = 18:39:00
B1 = $17.01
This is 18 hours, 39 minutes x $17.01.
C1 should equal $312.81
Instead it gives a value of $13.22
A1 is formatted for time
B1 is formatted for currency
C1 is formatted for currency
Time * currency = currency is what I want but the result is totally wrong.
I don't know how to fix it. Can anyone help?
Thank you very much for any help you may provide.