.... but of course, you will tell everyone that is was Bernie who solved it?

Bob

"T" wrote in message
...

That works!!! It took me a minute to figure out I needed to get rid of
the
page breaks -- but man am I going to look good.... Thank you
"Bernie Deitrick" wrote:

T,

With the 8 in cell A1, and the 1.2 in cell B1, the formula (watch it,
'cause
it'll be line wrapped)


=INT((INT(A1)+(A1-INT(A1))*2.5)-(INT(B1)+(B1-INT(B1))*2.5))+((INT(A1)+(A1-IN

T(A1))*2.5)-(INT(B1)+(B1-INT(B1))*2.5)-INT((INT(A1)+(A1-INT(A1))*2.5)-(INT(B
1)+(B1-INT(B1))*2.5)))/2.5

will return 6.2, and so on for all your examples.

HTH,
Bernie
MS Excel MVP

"T" wrote in message
...
where 8 is hours 1.2 = one hour 1/2 and 6.2 = six and a
half

need the same for the following on the same spreadsheet
1.1 = 1.25 and 1.3 = 1.75