Time range formula

Originally Posted by darkyam

I think DO's formula of =150*(CEILING(A1*24,0.1)) should work for you, now that we know your ranges are consistent.

Paul's works if you're only ever entering tenths of an hour. If you ever intend to enter say 2:33, then you'd need DO's.

Darky;

Thanks a lot for your comments and imput. This may sound very dumb but I don't know what means CEILING in the formula.

in my layout page I have Colum C for time and Colum D for amount

for example

concept time amount
review legal docs .6 150


Could you show me how to do it