I am trying to build a formula to let me know if of these 2 cells,Start & End, which ones have less than 1 hour (1:00) from start to finish, excluding those that have a blank in start or end. And to return true if less than 1 hour (1:00), false if over hour, and if the cell time range is negative, report it as true too. Please help!
Start--------------------------End
4/22/2013 11:00-------------
4/17/2013 16:00-------------
3/1/2013 9:00------------- 3/1/2013 9:45
3/8/2013 14:00-------------3/11/2013 13:06
3/15/2013 13:00-------------3/15/2013 12:44
Bill
Bookmarks