Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 06 May 2024 11:23:58 +0000
Post From: Need help with " Spreadsheet study "
| [2014-10-07 19:22:41] |
| Sawtooth - Posts: 3993 |
|
Refer to the WEEKDAY function documentation: http://office.microsoft.com/en-us/excel-help/weekday-HP005209336.aspx?CTT=5&origin=HP005204211 And use the 24 hr times in the TIMEVALUE function. =IF(AND(WEEKDAY(A3)=1,A4-INT(A4)<TIMEVALUE("17:00:00"),A3-INT(A3)>=TIMEVALUE("17:00:00")),B3,K4) |