Change Number to Time
 

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.

Change Number to Time
 

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.

Change Number to Time
 

Thank you very much, Steve. Your instruction works!!!

"SteveW" wrote in message
news:op.tm0y63s8evjsnp@enigma03...
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.

Change Number to Time
 

Glad they did -I do check them first :)

Steve

On Wed, 31 Jan 2007 16:06:59 -0000, Diane Walker wrote:

Thank you very much, Steve. Your instruction works!!!

"SteveW" wrote in message
news:op.tm0y63s8evjsnp@enigma03...
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.