| Home > Forum Home > Automating Data Analysis Tasks > How to Calulate if a Range of Times Falls Between two Date/Time Stamps > Solved | Share |
Solved
Excel Help for Solved in Automating Data Analysis Tasks
| Forum Topic | Login |
Solved | Rate this: (3/5 from 1 vote) |
 | Huron helped me answer this in the [http://www.excelforum.com/] His answer was: Your formula isn't working if the end time is after midnight because the time value is less than 18:15. Try the following formula Code: =IF(AND(MOD(H1,1)TIMEVALUE("18:00"),TRUNC(I1)>TRUNC(H1))),"Worked During Supper","") This worked great! | |
| Michaniker | ||
| Posted by Michaniker on | ||
| View Full Post |
Excel templates and solutions matched for Solved:Solutions: Financial Calculations |