how do i program excel to add two times together

[adam]

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

[RB Smissaert]

How about just adding them up:

11:19
00:41
12:00


RBS

"adam" <adam@discussions.microsoft.com> wrote in message
news:9CDD6905-F2E7-4BF0-BC65-A522C9F2A7E2@microsoft.com...
> 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

[adam]

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" <adam@discussions.microsoft.com> wrote in message
> news:9CDD6905-F2E7-4BF0-BC65-A522C9F2A7E2@microsoft.com...
> > 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
>
>

[RB Smissaert]

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" <adam@discussions.microsoft.com> wrote in message
news:E0B96FBD-2E14-47A6-B470-C9F13020F7B5@microsoft.com...
> 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" <adam@discussions.microsoft.com> wrote in message
>> news:9CDD6905-F2E7-4BF0-BC65-A522C9F2A7E2@microsoft.com...
>> > 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
>>
>>

[adam]

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" <adam@discussions.microsoft.com> wrote in message
> news:E0B96FBD-2E14-47A6-B470-C9F13020F7B5@microsoft.com...
> > 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" <adam@discussions.microsoft.com> wrote in message
> >> news:9CDD6905-F2E7-4BF0-BC65-A522C9F2A7E2@microsoft.com...
> >> > 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
> >>
> >>
>
>

[RB Smissaert]

Sub test()

Dim Time1 As Date
Dim Time2 As Date

Time1 = "11:19"
Time2 = "00:41"

MsgBox Time1 + Time2

End Sub


RBS


"adam" <adam@discussions.microsoft.com> wrote in message
news:11B66BE4-3E2E-40BA-AFC5-72C912C8D91C@microsoft.com...
>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" <adam@discussions.microsoft.com> wrote in message
>> news:E0B96FBD-2E14-47A6-B470-C9F13020F7B5@microsoft.com...
>> > 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" <adam@discussions.microsoft.com> wrote in message
>> >> news:9CDD6905-F2E7-4BF0-BC65-A522C9F2A7E2@microsoft.com...
>> >> > 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
>> >>
>> >>
>>
>>