| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Converting whole number to TIME
I have a whole number, like 11.5 and I want to convert it to 11:30, how do I do that. (i'd rather it not be in military time). -- B. Baumgartner ------------------------------------------------------------------------ B. Baumgartner's Profile: http://www.excelforum.com/member.php...o&userid=23107 View this thread: http://www.excelforum.com/showthread...hreadid=384011 |
|
#2
|
|||
|
|||
|
Divide by 24 and format as time
-- Kind regards, Niek Otten Microsoft MVP - Excel "B. Baumgartner" wrote in message news:B.Baumgartner.1rih2b_1120255503.9601@excelfor um-nospam.com... I have a whole number, like 11.5 and I want to convert it to 11:30, how do I do that. (i'd rather it not be in military time). -- B. Baumgartner ------------------------------------------------------------------------ B. Baumgartner's Profile: http://www.excelforum.com/member.php...o&userid=23107 View this thread: http://www.excelforum.com/showthread...hreadid=384011 |
|
#3
|
|||
|
|||
|
Divide the number by 24 and format the cell as time. If you want to do it
all in the same cell, enter 24 an unused cell, copy it and then Paste Special Divide into the cell(s) with the numbers. -- HTH Sandy Replace@mailinator with @tiscali.co.uk "B. Baumgartner" wrote in message news:B.Baumgartner.1rih2b_1120255503.9601@excelfor um-nospam.com... I have a whole number, like 11.5 and I want to convert it to 11:30, how do I do that. (i'd rather it not be in military time). -- B. Baumgartner ------------------------------------------------------------------------ B. Baumgartner's Profile: http://www.excelforum.com/member.php...o&userid=23107 View this thread: http://www.excelforum.com/showthread...hreadid=384011 |
|
#4
|
|||
|
|||
|
With the number in A1, use a helper cell:
=a1/24 format it as time. Ps. 11.5 is not a whole number <vbg. ===== If you have a whole bunch of cells to do, Put 24 in an empty cell. Copy it select the range to convert edit|paste special|check divide format that selection as time. "B. Baumgartner" wrote: I have a whole number, like 11.5 and I want to convert it to 11:30, how do I do that. (i'd rather it not be in military time). -- B. Baumgartner ------------------------------------------------------------------------ B. Baumgartner's Profile: http://www.excelforum.com/member.php...o&userid=23107 View this thread: http://www.excelforum.com/showthread...hreadid=384011 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| Converting Text to Number | Excel Discussion (Misc queries) | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Linear Mode
