Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
Member Login
Site Notices
11/24/2017 4:44:23 PM
11/22/2017 10:05:29 PM
Posted: 10/19/2004 12:02:44 AM EST
Anyone know how to format cells in an Excel spread sheet to change text numbers to a time format? Example would be 800 to 08:00 or 8:00 and 1700 to 17:00. I need to sort two different spread sheets to match certain entries. If I could change one of the spread sheets from text numbers to the time, I could make the matches much quicker.
Link Posted: 10/19/2004 12:09:58 AM EST
Link Posted: 10/19/2004 1:11:34 AM EST
[Last Edit: 10/19/2004 1:12:50 AM EST by Sewer_Urchin]
1. Click and drag over cells you wish to format.
2. Right Click. Select "number" tab.
3. Select "time"
4. Select desired format

[SNL annoying IT guy]You're welcome!! [/SNL annoying IT guy]
Link Posted: 10/19/2004 2:08:29 AM EST

Originally Posted By Sewer_Urchin:
1. Click and drag over cells you wish to format.
2. Right Click. Select "number" tab.
3. Select "time"
4. Select desired format

[SNL annoying IT guy]You're welcome!! [/SNL annoying IT guy]



Tried that. It just changes the numbers to "0:00".
Link Posted: 10/19/2004 2:14:42 AM EST
[Last Edit: 10/19/2004 2:14:50 AM EST by mjohn3006]

Originally Posted By smokycity:

Originally Posted By Sewer_Urchin:
1. Click and drag over cells you wish to format.
2. Right Click. Select "number" tab.
3. Select "time"
4. Select desired format

[SNL annoying IT guy]You're welcome!! [/SNL annoying IT guy]



Tried that. It just changes the numbers to "0:00".



Instead of time, go to custom. in custom, you type what you want. hh:mm will give you 08:00
Top Top