| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to assign unit for TimeValue?
I would like to input the number of minutes in cell A1 to set the Time Value,
as shown below there is 30 in cell A1 (Unit - minute). Does anyone have any suggestions on how to the value retrieve from cell A1 is under minute unit? Thanks in advance for any suggestions Eric Sheets("Date").Range(A1).Value, TimeValue(Sheets("Date").Range(A1).Value) TimeValue("00:30:00") |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign unit for TimeValue?
Divide by 1440 will convert that to excel time format....
Sub Macro() 'with 30 in cell A1 Range("B1") = Range("A1") / 1440 Range("B1").NumberFormat = "[h]:mm:ss" End Sub -- Jacob (MVP - Excel) "Eric" wrote: I would like to input the number of minutes in cell A1 to set the Time Value, as shown below there is 30 in cell A1 (Unit - minute). Does anyone have any suggestions on how to the value retrieve from cell A1 is under minute unit? Thanks in advance for any suggestions Eric Sheets("Date").Range(A1).Value, TimeValue(Sheets("Date").Range(A1).Value) TimeValue("00:30:00") |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign unit for TimeValue?
When I assign the value within cell B1, the TimeValue function is not working.
Do you have any suggestions? Thanks in advance for any suggestions Eric Sheets("Date").Range("B1") = Range("A1") / 1440 Sheets("Date").Range("B1").NumberFormat = "[h]:mm:ss" TimeValue(Sheets("Date").Range("B1").Value) "Jacob Skaria" wrote: Divide by 1440 will convert that to excel time format.... Sub Macro() 'with 30 in cell A1 Range("B1") = Range("A1") / 1440 Range("B1").NumberFormat = "[h]:mm:ss" End Sub -- Jacob (MVP - Excel) "Eric" wrote: I would like to input the number of minutes in cell A1 to set the Time Value, as shown below there is 30 in cell A1 (Unit - minute). Does anyone have any suggestions on how to the value retrieve from cell A1 is under minute unit? Thanks in advance for any suggestions Eric Sheets("Date").Range(A1).Value, TimeValue(Sheets("Date").Range(A1).Value) TimeValue("00:30:00") |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign unit for TimeValue?
Bonsour® "Eric" a écrit
I would like to input the number of minutes in cell A1 to set the Time Value, as shown below there is 30 in cell A1 (Unit - minute). Does anyone have any suggestions on how to the value retrieve from cell A1 is under minute unit? In other words : ;o))) http://www.cpearson.com/excel/DateTimeEntry.htm HTH @+ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy by timevalue to last row | Excel Programming | |||
| TimeValue formula | Excel Worksheet Functions | |||
| iserror(Timevalue()) | Excel Programming | |||
| OnTime / TimeValue | Excel Programming | |||
| DATEVALUE and TIMEVALUE | Excel Programming | |||
Hybrid Mode
