formula to add time elapsed

[twills44]

I used this formula:

For subtracting times, if the difference is less than 24 hours, the earlier
time is in B1 and the later time in A1,

=HOUR(B1-A1)
But now my issue is that it only adds the hours rounded to the next whole
number. I need it to give me any fractions of time also...so if it was from
17:30-20:45 I need the result to be 3.25 but it's only giving me 3.00. How do
I fix this problem?

 

[JE McGimpsey]

One way:

=MOD(B1-A1,1)*24