simplifying an IF statement

[Tucker92]

I created an IF statement that is a bit extreme. I wanted to be able to account for break times between 10:15 and 10:30 and 1:00 to 1:30 and then at the end of the day start again basing it around how long something takes to do.

=IF(AND(A1>TIME(10,15,0),A1<TIME(10,30,0)),TIME(10,15,0)-(TIME(10,30,0)-A1),IF(AND(A1>TIME(13,0,0),A1<TIME(13,30,0)),TIME(13,0,0)-(TIME(13,30,0)-A1),IF(AND(A1>TIME(16,15,0),A1<TIME(7,30,0)),TIME(16,15,0)-(TIME(7,30,0)-A1),A1)))

Can anyone let me know if there is a more simple way to do this. It does work but I wanted to something similar on another spread sheet and was just wondering.

Thank you

 

[Tucker92]

Sorry Only half of it actually appeared here it is in chunks

=IF(AND(A1>TIME(10,15,0),A1< TIME(10,30,0)),TIME(10,15,0)-(TIME(10,30,0)-A1)
,IF(AND(A1>TIME(13,0,0),A1< TIME(13,30,0)),TIME(13,0,0)-(TIME(13,30,0)-A1)
,IF(AND(A1>TIME(16,15,0),A1< TIME(7,30,0)),TIME(16,15,0)-(TIME(7,30,0)-A1),A1)))

 

[Peter_SSs]

There is a problem rendering to the forum when a < sign is followed immediately by a letter. I have fixed your second post by inserting a space between.