Marcster
07-09-2014, 08:17 AM
Hi People,
I'm currently doing this manually :( and I'm pretty sure there's a formula(s) to do this, as a sample:
Column A
Column B
Column C
Column D
Column E
Weekday
Monday to Friday 09:00 to 17:00
Non Working/Out of Hours
Wednesday 19:30 to 21:00
30/06/2014 16:56
Monday
Y
30/06/2014 17:46
Monday
Y
25/06/2014
Wednesday
Y
In column C I want a 'Y' displayed if:
Column A same row, is a Weekday(Monday to Friday) and the time is between 09:00 and 17:00
Column E I want a 'Y' displayed if:
Column A same row, is a Wednesday and time is between 19:30 and 21:00
Column D I want a 'Y' displayed if:
Column A same row, is not Monday to Friday 09:00 to 17:00 or Wednesday 19:30 to 21:00
Thanks :help
I'm currently doing this manually :( and I'm pretty sure there's a formula(s) to do this, as a sample:
Column A
Column B
Column C
Column D
Column E
Weekday
Monday to Friday 09:00 to 17:00
Non Working/Out of Hours
Wednesday 19:30 to 21:00
30/06/2014 16:56
Monday
Y
30/06/2014 17:46
Monday
Y
25/06/2014
Wednesday
Y
In column C I want a 'Y' displayed if:
Column A same row, is a Weekday(Monday to Friday) and the time is between 09:00 and 17:00
Column E I want a 'Y' displayed if:
Column A same row, is a Wednesday and time is between 19:30 and 21:00
Column D I want a 'Y' displayed if:
Column A same row, is not Monday to Friday 09:00 to 17:00 or Wednesday 19:30 to 21:00
Thanks :help