Format time as decimal?
 

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

Format time as decimal?
 

Hi Roberta

Time is stored as fractions of a day (24 hours) so just multiply your
cell by 24 e.g =A1*24
Set cell Format to General
5:40 will give a result of 5.6667

--
Regards

Roger Govier


"Roberta" wrote in message
...
Is there a formula that will convert the time 5:40 to a decimal to
5.40?

Format time as decimal?
 

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