including date and time in one function

A

ams228

I am trying to make a worksheet that will return a value during
certain time period. For example: On Monday at 8:00-9:00, I would lik
it to display a different value than the same time on Tuesday. Also,
need it to show a different value later on in the same day. I canno
figure out if there is a way to combine DATEVALUE and TIMEVALUE, nor a
i sure if a combination of the two is what is exactly what I want, bu
it is somewhere along those lines. I would appreciate any help tha
anyone can give me
 
F

Frank Kabel

Hi
you can add them. e.g. try
=IF(AND(A1>=DATE(2004,1,1)+TIME(8,0,0),A1<DATE(2004,1,1)+TIME(9,0,0)),"
Between 8:00 and 9:00 on 1st Jan 2004","")
 
Top