Help in converting duration to hrs format

[gloom52]

I have this set of time that is in eg. 0800 to 1630

how do i make it in to a 8.5hrs figure

[shg]

=(b1-a1)*24 and format as 0.0

[teylyn]

Hi

Are your values time values? If so, this will work:

Say A1 has 8:00 and A2 has 16:00 (both time values), calculate the difference with

=A2-A1

and format as time value. Say you put this in A3. Then you can use

=HOUR(A3)+(MINUTE(A3)/60)

This must be formatted as "General" and will show as 8.5

[teylyn]

As usual, SHG's solution is much more elegant!