I am trying to calculate the length of stay for patients in a medical facility. Most stay less than 24 hours, so I simply use the =MOD(B1-A1,1) formula.

If they stay longer than 24 hours, an incorrect (the correct time would be the incorrect time plus 24 hours) time is given. Is there a simple way to "add" 24 hours to this incorrect time to make it legitimate, without adding 24 hours to the times that are already correct?

Thanks in advance!