Support Board

Date/Time: Mon, 06 May 2024 15:39:57 +0000

Post From: Need help with " Spreadsheet study "

[2014-10-07 18:53:08] Link To Thread - Link To Post [Go To First Post]
User48557 - Posts: 138
=IF(AND(WEEKDAY(A3)=2,A4-INT(A4)<TIMEVALUE("08:30:00"),A3-INT(A3)>=TIMEVALUE("08:30:00")),B3,K4) Is a formula that starts a line at 8:30 am Monday and goes till next Monday at 8:30 am then starts another line and so on. What would the formula be or how would the formula differ if I wanted to start a line on Sunday at 5 pm to do the same? I have little to no spreadsheet experience so if you can write it out as the other formula is.