=A1*24 and format as General.

If your app absolutely requires two and only two decimal digits, then:

Format Cells... Number Number and specify 2 digits
--
Gary''s Student - gsnu2007g


"Greg Maxey" wrote:

I have a simple spreadsheet for determining the hours and minutes that an
employee works during a pay period. The current result is formatted like
"38:45" meaning 38 hours and 45 minutes. My payroll software needs the
time worked in decimal format (i.e., 38.75).

Can someone please show me how I would use an Excel formula to covert hours
and minutes to hours and fraction of hours. Thank you.



--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~