Hi Gringarlow,

Perhaps you should simply use =A1/24 and format the result as 'time'.

--
Cheers
macropod
[MVP - Microsoft Word]


"Gringarlow" wrote in message ...
My data for work time is
1.1
1.017
etc...
I need to convert this to
1:06
1:01
etc..
and have this data be used in a Pivot Table that shows the average time of
all of these cells. When I convert using =TEXT(A1/24,"h:mm"), I get #DIV/0 in
the Pivot Table. Thanks