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

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

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

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

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

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