| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i program excel to add two times together
how do i program excel to add two times together?
i am trying to create a log sheet for run times for a tv station |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i program excel to add two times together
How about just adding them up:
11:19 00:41 12:00 RBS "adam" wrote in message ... how do i program excel to add two times together? i am trying to create a log sheet for run times for a tv station |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i program excel to add two times together
how do i get it to add them up i do not know much about excel
"RB Smissaert" wrote: How about just adding them up: 11:19 00:41 12:00 RBS "adam" wrote in message ... how do i program excel to add two times together? i am trying to create a log sheet for run times for a tv station |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i program excel to add two times together
If you have 11:19 in cell A1 and 00:41 in cells A2 and in cell A3:
= A1 + A2 then you get 12:00 in A3 Or are you talking about coding this in VBA? RBS "adam" wrote in message ... how do i get it to add them up i do not know much about excel "RB Smissaert" wrote: How about just adding them up: 11:19 00:41 12:00 RBS "adam" wrote in message ... how do i program excel to add two times together? i am trying to create a log sheet for run times for a tv station |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i program excel to add two times together
i think this might work but how woyld you do it in vba?
"RB Smissaert" wrote: If you have 11:19 in cell A1 and 00:41 in cells A2 and in cell A3: = A1 + A2 then you get 12:00 in A3 Or are you talking about coding this in VBA? RBS "adam" wrote in message ... how do i get it to add them up i do not know much about excel "RB Smissaert" wrote: How about just adding them up: 11:19 00:41 12:00 RBS "adam" wrote in message ... how do i program excel to add two times together? i am trying to create a log sheet for run times for a tv station |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i program excel to add two times together
Sub test()
Dim Time1 As Date Dim Time2 As Date Time1 = "11:19" Time2 = "00:41" MsgBox Time1 + Time2 End Sub RBS "adam" wrote in message ... i think this might work but how woyld you do it in vba? "RB Smissaert" wrote: If you have 11:19 in cell A1 and 00:41 in cells A2 and in cell A3: = A1 + A2 then you get 12:00 in A3 Or are you talking about coding this in VBA? RBS "adam" wrote in message ... how do i get it to add them up i do not know much about excel "RB Smissaert" wrote: How about just adding them up: 11:19 00:41 12:00 RBS "adam" wrote in message ... how do i program excel to add two times together? i am trying to create a log sheet for run times for a tv station |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate times between dates and times in Excel | Excel Discussion (Misc queries) | |||
| Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| Slow in program after running few times | Excel Programming | |||
| merging excel program with tdc finance program | Excel Programming | |||
Linear Mode
