Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a cell with a format of "hh:mm AM/PM" and
another cell in a numerical format of "0.75". I want to using VBA, add the numerical value to the time to create a new time, such as: A1= 7:30 AM B1 = 0.75 ' 45mins C1= 8:15 AM ' Result. I cannot seem to get the correct syntax to add the value to give me the desired result. If i format the numerical value as "hh:mm" it changes from 0.75 to 18:00 ? How can i do this: Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a Leter to a Numerical Value on Exit | Excel Programming | |||
Giving letters a numerical value, then adding the total. | Excel Discussion (Misc queries) | |||
Adding up non numerical values | New Users to Excel | |||
Adding numbers to an incomplete numerical list | Excel Discussion (Misc queries) |