hello all,
I need to calculate a specific value everyday at specific hour and I don't
know how to concatenate the time to the TODAY() function.
example:
I added in A1 the TODAY() function so that gives me 8/10/2006 and I have in
B1 cell 5:00 AM, anbd in B2: 8:00 AM, and B3: 13:00,..etc
I need only one cell that combines these two cells A1, B1
so I can go ahead and do the same for A1, B2 and A1, B3,..etc

does anyone one know how?

thanks

You can add dates and times together, like:

=A$1+B1

and format the cell as Custom and choose a format from the scrollable
list. This assumes that your times in column B are actual Excel-format
times.

The formula can be copied down.

You might also think about using the NOW( ) function, as this includes
the time element.

Hope this helps.

Pete

netasp wrote:
> hello all,
> I need to calculate a specific value everyday at specific hour and I don't
> know how to concatenate the time to the TODAY() function.
> example:
> I added in A1 the TODAY() function so that gives me 8/10/2006 and I have in
> B1 cell 5:00 AM, anbd in B2: 8:00 AM, and B3: 13:00,..etc
> I need only one cell that combines these two cells A1, B1
> so I can go ahead and do the same for A1, B2 and A1, B3,..etc
>
> does anyone one know how?
>
> thanks

Thanks Pete, it worked!
"Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You can add dates and times together, like:
>
> =A$1+B1
>
> and format the cell as Custom and choose a format from the scrollable
> list. This assumes that your times in column B are actual Excel-format
> times.
>
> The formula can be copied down.
>
> You might also think about using the NOW( ) function, as this includes
> the time element.
>
> Hope this helps.
>
> Pete
>
> netasp wrote:
>> hello all,
>> I need to calculate a specific value everyday at specific hour and I
>> don't
>> know how to concatenate the time to the TODAY() function.
>> example:
>> I added in A1 the TODAY() function so that gives me 8/10/2006 and I have
>> in
>> B1 cell 5:00 AM, anbd in B2: 8:00 AM, and B3: 13:00,..etc
>> I need only one cell that combines these two cells A1, B1
>> so I can go ahead and do the same for A1, B2 and A1, B3,..etc
>>
>> does anyone one know how?
>>
>> thanks
>

Glad to be of help - thanks for feeding back.

Pete

netasp wrote:
> Thanks Pete, it worked!
> "Pete_UK" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > You can add dates and times together, like:
> >
> > =A$1+B1
> >
> > and format the cell as Custom and choose a format from the scrollable
> > list. This assumes that your times in column B are actual Excel-format
> > times.
> >
> > The formula can be copied down.
> >
> > You might also think about using the NOW( ) function, as this includes
> > the time element.
> >
> > Hope this helps.
> >
> > Pete
> >
> > netasp wrote:
> >> hello all,
> >> I need to calculate a specific value everyday at specific hour and I
> >> don't
> >> know how to concatenate the time to the TODAY() function.
> >> example:
> >> I added in A1 the TODAY() function so that gives me 8/10/2006 and I have
> >> in
> >> B1 cell 5:00 AM, anbd in B2: 8:00 AM, and B3: 13:00,..etc
> >> I need only one cell that combines these two cells A1, B1
> >> so I can go ahead and do the same for A1, B2 and A1, B3,..etc
> >>
> >> does anyone one know how?
> >>
> >> thanks
> >