Time In/Time Out/Time In/Time Out calculations

[JWatson]

I am trying to set up a spreadsheet to track daycare hours per day. The issue is that I can have up to 3 Time In/Time Out per day.
[TABLE="width: 421"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col span="4"><col><col></colgroup>[/TABLE]

Time In Time Out Time In Time Out Time In Time Out Total Hours
8:00am 10:00am 12:00am 1:30pm 3:20pm 5:30pm **Need a formula to figure out hours used for all 3 time in/time outs

Can anyone help?

 

[Fishboy]

I am trying to set up a spreadsheet to track daycare hours per day. The issue is that I can have up to 3 Time In/Time Out per day.
[TABLE="width: 421"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Time In Time Out Time In Time Out Time In Time Out Total Hours
8:00am 10:00am 12:00am 1:30pm 3:20pm 5:30pm **Need a formula to figure out hours used for all 3 time in/time outs

Can anyone help?

Hi JWatson,

The first thing you are going to want to do is set the format of the filled cells to time and use a 24hr clock system with the am / pm suffix. This will allow better handling of the values for calculating.

Once this has been done, and assuming your data then looks like this starting in A1...

Excel 2010
	A	B	C	D	E	F	G
1	Time In	Time Out	Time In	Time Out	Time In	Time Out	Total Hours
2	08:00:00	10:00:00	12:00:00	13:30:00	15:20:00	17:30:00	05:40:00
Sheet1

The formula in G2 is: =SUM((B2-A2)+(D2-C2)+(F2-E2))