Hello, 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 hourI 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.

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.

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.

Still causes errors with a negative, guess I will just have to use time as a fraction instead.

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.MIKE

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History