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?