Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???

[KC1952]

I am trying to calculate the time between 8:00 am and 4:30 pm. It is giving
me 8 hours only and not the 8.5 hrs. Is there a way I can do this?

 

[Bernard Liengme]

With A1 displaying 8:00 AM, and B1 displaying 4:30 PM, the formula =B1-A1
results in 8:30 when the cell has format h:mm. The formula =(b1-A1)*25
displayed 8.5 when General format

If you need to cross midnight, use =(B1-A1)+(A1>B1) the last term add 1 to
the results of the subtraction
best wishes & Merry Christmas

 

[David Biddulph]

Wouldn't you prefer *24, rather than *25, Bernard?

 

[Bernard Liengme]

Any "day" but I have been in the egg-nog.
Tanoaks for the correction