A2 = 100
A3 = 90 etc etc.

B2 = A2/60/24
Format B2 as hh:mm

Steve
On Wed, 31 Jan 2007 15:29:58 -0000, Diane Walker wrote:

We are running Excel 2003. I exported data into Excel. This data is a
numeric field. For example, I would like to convert the number 100 to 1
hour 40 minutes; number 90 to 1 hour 30 minutes, etc. Is there a way to
set
it up in Excel? Thanks.