Format time as decimal?

R

Roger Govier

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
 
R

Ron Rosenfeld

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


=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
 
Top