T wrote...
so if i add*.4 to the end of this formula will it produce an answer of
..1
or.2 or .3 as thiese aee the increments i need the hour is split
inot
quarters and these numbers designate .25 .50 and .75
....

I didn't reformat the result. Thinking about it, it makes more sense to
convert back and forth between fractional formats.

For an arbitrary range, Rng, change the formula to

=--SUBSTITUTE(SUBSTITUTE(TEXT(SUM(--(SUBSTITUTE(Rng,"."," ")
&IF(MOD(Rng,1),"/4",""))),"0 0/4"),"/4","")," ",".")