Support Board

Date/Time: Sun, 06 Sep 2026 10:20:48 +0000

Post From: Need help with " Spreadsheet study "

[2014-10-07 19:22:41] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4350
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)