Goodmorning all,

i need urgent help as im stuck with this.

to convert time into decemel i believe this is the formula
=HOUR(Cell Number)+MINUTE(Cell Number)/60

so,

lets say if
A1 : 07:00
A2 : 08:30

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

i dont want this. i want B2 and B1 in the same cell .. meaning :

i want the result in B1 to be 1.5 ...not 1hr 30min . i dont want 2 cells to get my result i want .
also keep in mind that i want the number to be rounded
each 6 minute = .1

purpose of this excel formula is for aviation industry .. calculting flight time and block time


thank you for your help


regards,
Hani