Multiply with 24 and set the Number format to general.

HTH
Kostis Vezerides

sako 338 wrote:
how do i convert a difference between two times (say the result is 1:30 in
h:mm format) back to a number (1.5)

all help appreciated