Adding Date and Time?

N

netasp

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
 
P

Pete_UK

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
 
N

netasp

Thanks Pete, it worked!
Pete_UK said:
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
Click to expand...
 
Top