Computers & Internet » Software » Excel Time calculations help?

Excel Time calculations help?

Hi, i am working with excel for some time calculations, what i need is to have times at which some machines will be operating, i have start time, running time, and the time when the machine will be ready for next run, and according to the time needed for the machines to run, i have a table for a week of running the machines, the problem is that i found out that some of the times when the machine is supposed to start working is at 5 am for example, and that's out of the work hours, so how can i add to the cells some kind of contraint that will give me results only between 6:30AM and 1:30 AM of the next day, HELP PLZ!

2 Answers2