The main story in FF16's The Rising Tide DLC is roughly two to five hours
long, depending on how challenging you find the expansion's various
battles. With The Rising Tide being endgame content, you might end up
losing some time to the expansion's nastier foes, especially if you're
playing on a harder difficulty.
How Long Is FF16: The Rising Tide DLC?