What's wrong in this formula????

[Ekser]

In G19 I insert a whole number: 1 to 10. (only one number)!
In J19 I have the following formula: =(I19-H19)*24 - two time cells ar
substracted and passed into a cell (J19) that has the format number, tw
decimals. Here I can havevalues like this: 2.00, 2.50, 2.75 etc.






Cheers

 

[Ken Wright]

Using your ranges I19 and H19

H19 = 14:29
I19 = 18:29

J19 using your formula returns 4

In G19 I put a 3 and the formula returns 450

 

[Don Guillett]

Perhaps your formula should then have > instead of = or use what I sent
which will allow for the fractions in j19