Support Board
Date/Time: Wed, 27 Nov 2024 22:46:45 +0000
Post From: Need help with " Spreadsheet study "
| [2014-10-07 18:53:08] |
| 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. |