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