Forum Discussion
Calculating time between sheets
- Sep 15, 2020
I agree with Riny_van_Eekelen
The safest option is to include the dates in the calculation of elapsed time
= (endDate+endTime) - (startDate+startTime) = MOD(endTime -startTime, 1)
The second option is only usable if you are certain the elapsed time will never exceed 24hrs.
The number format you require is [h]:mm unless you choose to multiply by 24 and output the result as decimal hours, in which case it would be 0.0 "hours" .
The ranges defined for your dried weight calculations are incorrect and include the total itself, so giving rise to circular references.
I agree with Riny_van_Eekelen
The safest option is to include the dates in the calculation of elapsed time
= (endDate+endTime) - (startDate+startTime)
= MOD(endTime -startTime, 1)
The second option is only usable if you are certain the elapsed time will never exceed 24hrs.
The number format you require is [h]:mm unless you choose to multiply by 24 and output the result as decimal hours, in which case it would be 0.0 "hours" .
The ranges defined for your dried weight calculations are incorrect and include the total itself, so giving rise to circular references.
I saw your comment at the bottom and went in and checked, do not know how that happened, I know better then to do that and also didn't check that either because wouldn't have know it had executed it like that. Made changes and it works. Thank you.
For the time, you are saying your equation will work if the time is more than 24 hours. Which I have an occasional fruit that does go over 24 hours.
Thank you.