| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change text to military time | Excel Worksheet Functions | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
| Histograms: how change number of bins | Excel Discussion (Misc queries) | |||
Linear Mode
