On Fri, 2 Mar 2007 09:58:35 -0800, Roberta
wrote:

Is there a formula that will convert the time 5:40 to a decimal to 5.40?


=DOLLARFR(A1*24,60)

Format the cell as Number with 2 decimals.

If you don't have, or want, the Analysis Tool Pak installed (see HELP for
DOLLARFR for instructions), then you could use:

=INT(A1*24)+MOD(A1*24,1)*60/100
--ron