Managing Time Calculations

[kkline116]

Hello all,

I know there are a ton of threads on calculating time and I read a bunch and tried a bunch, but not finding anything that works for what I'm looking for (or at least that I can figure out).

I'm trying to keep track of time a machine runs. See example below

End goal is to have a spreadsheet where I can just enter start times and end times (which will vary greatly with different lengths of breaks) and it spit out correct hours worked on the right (and them sum all those up in the top left for "Total Hours").

I do have the dates in column A... do I have to incorporate them somehow?

[TABLE="width: 800"]
<tbody>[TR]
[TD]Total Hours[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD](total hours here)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Time Start[/TD]
[TD]Time Stop[/TD]
[TD]Time Start[/TD]
[TD]Time Stop[/TD]
[TD]Hours Ran[/TD]
[/TR]
[TR]
[TD]Monday, May 21, 2018[/TD]
[TD]10 a[/TD]
[TD]12 a[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tuesday, May 22, 2018[/TD]
[TD]12 a[/TD]
[TD]3 a[/TD]
[TD]8 a[/TD]
[TD]8 p[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wednesday, May 23, 2018[/TD]
[TD]8 a[/TD]
[TD]4 p[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thursday, May 24, 2018[/TD]
[TD]7:30 a[/TD]
[TD]12 a[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Friday, May 25, 2018[/TD]
[TD]12 a[/TD]
[TD]1 pm[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


So, in this above example, We started the machine Monday morning, and ran into Tuesday morning 3 am... we came in, started the machine at 8 am, and it ran until 8 pm. Wed, it ran from 8 am until 4 pm. Then we started it again Thursday at 7:30 am, and run until Friday at 1 pm.

And every week these times can adjust wildly with no set time or break pattern.

What formula would you put in the "Hours Ran" cells to calculate that?

 

[kkline116]

I figured it out.... it's in the MOD function:

=MOD((D5-C5)+(F5-E5),1)