Excel cost per hour with negative

September 15, 2012 at 22:31:10
Specs: Windows 7

I have ran into some problems where negative numbers are messing with me spreadsheet.

I have 3 columns

A1= value, both negative and positive
B1= time
c1=result of gain or loss per hour

I searched google and found a few formulas that work fine until thee is a negative number.

=A1*B1*24 gives the wrong loss per hour if a! is a negative.

Thank you for your help.

See More: Excel cost per hour with negative

September 16, 2012 at 06:26:34
I don't fully understand what you are trying to do, but I will tell you that Excel can not work with "negative times".

Please post some examples of your data and the expected results based on that data and we'll try to help.

Please click on the following line and read the instructions found via that link before posting your data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

September 16, 2012 at 07:35:28
Thank you, I hope I can explain it better this time.

     A1         B1          C1
   -110.98     0:56         ???

I found =A1*B1*24 for C1 on another forum, but it does not work with negative numbers.

For some background:

This is a sheet to track gains or loss in a game per hour.  A1 can be + or -,  
B1 will always be a time & C1 should be the result.

It works fine for positive numbers, but fails on the negatives.

I was wondering if there was a way to trick it around this, maybe not use a 
negative(in the background) but to display it as a negative in the result(c1)

What I would like it to do is pull the amount from A1, ignore if it is a positive 
or negative, perform the calculation and input the result into C1, then if it was a 
negative in A1 and a - before the number.

Just have not figure out how yet or an easier way around it.

Thank you for your time.

Report •

September 16, 2012 at 13:14:55
Try this:


See if that works.



Report •

Related Solutions

September 17, 2012 at 05:37:27
Still causes errors with a negative, guess I will just have to use time as a fraction instead.

Report •

September 17, 2012 at 06:07:35
When I use your figures:

     A1         B1          C1
   -110.98     0:56         ???

and in cell C1, which is formatted as Number, with 2 decimal places and use this formula: =A1*(B1*24)

I get an answer of: -103.58

Is this what you were expecting?
You did not offer a great many examples.



Report •

Ask Question