Hi, I'm having an issue with an IF statement in regards to time of day, such as a morning/afternoon/night shift dataset. All the formulae looks correct to me and yet I'm still not getting any joy on the timed IF function. An example of the line I'm using is shown below, any help would be appreciated.
=IF('Input Data'!B4="",0,IF(AND(TIMEVALUE("16:00:01")<='Input Data'!B3,'Input Data'!B3<=TIMEVALUE("23:30:00")),IF(('Input Data'!B4-'Input Data'!C3)<=TIMEVALUE("00:00:20"),('Input Data'!B4-'Input Data'!C3)+'Input Data'!D3,FALSE)))
Bookmarks