I like to handle mysteries the way I handle most games…timed in the real world. Equal timing for each part. Set the scene…discover the issue…follow the clues.. solve the case…deal with the aftermath. If the time elapses, just move the plot along, and raise difficulty a bit for missing clues.