Raw Material Tracking

Originally Posted by sajeelqaiservohra

What I am doing is this

16 8-Jul Thursday 36
33 9-Jul Friday 45
33 10-Jul Saturday 59
11-Jul Sunday 35
33 12-Jul Monday 64
13-Jul Tuesday 40
14-Jul Wednesday 16

A = Time in Hours
B = IF(D3>24,B3+1," ")
C = day
D = (IF(D3>24,D3-24,0))+A4



I need help with this working

33 8-Jul Thursday 53
9-Jul Friday 29
10-Jul Saturday 5
33 Sunday 33
#VALUE! Monday 9
Tuesday 0
44 Wednesday 44
#VALUE! Thursday 20


I get these errors in this model

I am looking for a model that uses Time and Date or other commands for time tracking of raw material rather than "IF" commands
awaiting response
Regards
Sajeel