Change Number to Time

[Diane Walker]

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.

 

[SteveW]

A2 = 100
A3 = 90 etc etc.

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

Steve

 

[Diane Walker]

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

A2 = 100
A3 = 90 etc etc.

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

Steve

 

[SteveW]

Glad they did -I do check them first

Steve

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

A2 = 100
A3 = 90 etc etc.

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

Steve