Gringarlow wrote:
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

Don't convert the number to text, divide by 24 and display in an appropriate
time format.