Convert time into Decimel

Originally Posted by guitarist00

then
B1 should be =(A2-A1) which is 1hr 30 Min

i can convert that number in another cell for Example :
B2 =HOUR(B1)+MINUTE(B1)/60 which will give me 1.5

=HOUR(A2-A1)+MINUTE(A2-A1)/60

if it's working for you using 2 cells, to reduce it into one cell, replace the cell reference in the formula with the calculation it was doing

thx!

that was fast and Easy

lol

regards,
Hani

You're welcome.

thx all. that was very helpfull

i have another question ill post soon which is more complicated . i give up with the next one after couple of hours lol


regards,
Hani