Breakout total time into 15 minute intervals

[mbesspiata]

I need a formula to take total time (from time in to time out) and extrapolate how many 15 minute intervals are in that total time.
This is for determining how many units (15 minute intervals) an individual should get paid for.

Any help is appreciated.

 

[AhoyNC]

Either of these formulas should due what you want. You may want to wrap them in the ROUND function to get whole numbers.

Excel Workbook
	A	B	C	D
1	Time In	Time Out
2	7:00 AM	1:00 PM	24	24
3	12:00 PM	1:42 PM	6.8	6.8
Sheet

 

[mbesspiata]

Thank you so much. This is exactly what I needed. I don't want to round up but I want it to round down. Do I just put a rounddown in front of the formula?

 

[AhoyNC]

Yes, ROUNDDOWN.

Excel Workbook
	A	B	C	D
1	Time In	Time Out
2	7:00 AM	1:00 PM	24	24
3	12:00 PM	1:42 PM	6	6
Sheet

 

[mbesspiata]

Thank you again. Your help is greatly appreciated.

 

[AhoyNC]

You're welcome. Thanks for the feedback.