Forum Discussion
Solved
Calculating time between sheets
I have a sheet that receives all the inputs for our production including time started and time finished. The times inserted can be from one day to the next. I have not been able to subtract the ...
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.
Sockens Since you already have the dates in your schedule in C1 and D1, why not simply use
=(D1+D5)-(C1+C4)and custom format as [h]:mm, just to be sure to calculate duration in stead of time. Result will be 15:10