Good morning, I'm working on a distance, speed and time calculator and came up with a discrepancy. If I take let's say 100 miles and want to find out how long it takes to travel that distance based on 20 mph I get 5 hours using this formula =IFERROR(IF(D3="","",(D3/E3)/24),""). However, if I break down the distance into segments that add up to 100 miles, I end up with 5 hours 4 minutes and 19 seconds. I am using this formula to calculate the time: =IFERROR(IF(D3="","",(D3/E3)/24),""). Why is there a 4 minute and 19 seconds difference?