| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number to Time
Here's what I have: Code ------------------- tih = Selection ActiveCell.Offset(0, 1).Select tih2 = Selection ActiveCell.Offset(0, 2).Select tim = Selection ActiveCell.Offset(0, 1).Select tim2 = Selection TimeIn = tih & tih2 & tim & tim ------------------- TimeIn = "0745" How do I make the expression TimeIn have a value of 7:45 instead o 745 -- hyyft ----------------------------------------------------------------------- hyyfte's Profile: http://www.excelforum.com/member.php...fo&userid=1318 View this thread: http://www.excelforum.com/showthread.php?threadid=26549 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number to Time
Try: Code ------------------- tih = Selection ActiveCell.Offset(0, 1).Select tih2 = Selection ActiveCell.Offset(0, 2).Select tim = Selection ActiveCell.Offset(0, 1).Select tim2 = Selection TimeIn = TimeSerial(tih & tih2, tim & tim2, 0 ------------------- -- kkkni ----------------------------------------------------------------------- kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754 View this thread: http://www.excelforum.com/showthread.php?threadid=26549 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number to Time
With Selection
TimeIn = TimeSerial(.value& .Offset(0,1).value, .Offset(0,3).value& ..Offset(0,4).value, 0) End With -- HTH RP "hyyfte" wrote in message ... Here's what I have: Code: -------------------- tih = Selection ActiveCell.Offset(0, 1).Select tih2 = Selection ActiveCell.Offset(0, 2).Select tim = Selection ActiveCell.Offset(0, 1).Select tim2 = Selection TimeIn = tih & tih2 & tim & tim2 -------------------- TimeIn = "0745" How do I make the expression TimeIn have a value of 7:45 instead of 745? -- hyyfte ------------------------------------------------------------------------ hyyfte's Profile: http://www.excelforum.com/member.php...o&userid=13187 View this thread: http://www.excelforum.com/showthread...hreadid=265496 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert time stored as decimalised number to time format | New Users to Excel | |||
| number to time | Excel Worksheet Functions | |||
| time into a number | Excel Discussion (Misc queries) | |||
| Every time i put a number with period it becomes a date and time | Excel Discussion (Misc queries) | |||
| Time to number | Excel Worksheet Functions | |||
![hyyfte[_23_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
