Convert time into Decimel

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

Try

=(A2-A1)*24

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