RE: If statement using time of day
- From: Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com">
- Date: Mon, 8 Dec 2008 10:46:01 -0800
Try
=IF(AND(E2>=TIME(6,0,0),E2<TIME(18,0,0)),"Shift1","Shift2")
"BAKERSMAN" wrote:
I need to have E2 return a specific value based on the time of day..
If E2 is greater than or equal to 0600 but less than 1800 then I need to see
shift 1
If E2 is greater than or equal to 1800 but less than 0600 then I need to see
shift 2
- Follow-Ups:
- RE: If statement using time of day
- From: BAKERSMAN
- RE: If statement using time of day
- References:
- If statement using time of day
- From: BAKERSMAN
- If statement using time of day
- Prev by Date: cumulative total
- Next by Date: External data connection needs separate login for each query
- Previous by thread: If statement using time of day
- Next by thread: RE: If statement using time of day
- Index(es):
