Try this:

=SUMPRODUCT(TIME(INT(A1:A45),MOD(A1:A45,1)*100,0)* 24)

Biff

"Headacheaday" wrote in message
...
Biff.. thanks it worked great. Now I need to add an entire column, of
numbers.
A1:A45 Is there a way to do this without having to enter the formula you
gave me
for each cell in the total cell.
i.e. =TIME(INT(A1),MOD(A1,1)*100,0)*24 then I need to do the same thing
for cells A2 through A45. That would be a very long formula.
Thanks again for all your help.



"Headacheaday" wrote:

On our timesheets we must enter quarter hours as .15, .30, .45. Is there
a
way to
enter these decimals but have excel calculate them as .25, .50, .75.
Thanks,