If statement to compare time cell to a time
Good Stuff Luke - Thanks. It worked. - Russ
--
Z-Man
"Luke M" wrote:
Your time statements are wrong. You need to use commas to seperate, not colons.
E.g, time(6,0,0)
--
Best Regards,
Luke M
"Z-Man-Cek" wrote:
Hi Friends,
Here's the equation that isn't working:
=if(and(E5<$A$2,F5time(06:00:00),F5<=time(14:00:0 0)),"1st
Shift",if(and(E5<$A$2,F5time(14:00:00)),"2nd
Shift",if(and(E5=$A$2,F5<=time(06:00:00)),"2nd Shift","Do Not Count")))
I want it to exclude values prior to 6 AM yesterday and after 6 AM today.
A2 is today. I want it to split the included values into 1st shift and 2nd
shift. 1st shift if from 6:00 AM to 14:00 PM. 2nd Shift is from 14:01 to
6:00 AM today. Column F is formatted as "time" and looks like this
"13:01:15."
Help and Thanks!
--
Z-Man
|