time calculations

[Mei_Mienzi]

I am trying to set up a spread sheet that will calculate the number of hours based on the times employees clock in and out each day and then give me a total for the time period.

I have found lots of templates but every last one of them has a problem I don't know how to overcome. If I have an employee that clocks in at 9 pm and clocks out at 12 pm (same problem with am times), when I put those hours into all of the templates am getting 9 hours.

I am also having trouble where an employee clock in at say 10 pm and clocks out at 3 am. In this case the spread sheet shows -19 hours.

To complicate matters further I have employees who work from am to am and from am to pm and visa-versa on the same time card.

Any suggestions or templates that really work?

Thanks

 

[Scott Huish]

Here's the formula for dealing with times that can cross midnight.

=MOD(B1-A1,1)

Format as h:mm

Your 9PM, 12PM example is 15 hours. If you meant 9PM, 12AM that would be 3

Excel 2010
	A	B	C
1	10:00 PM	3:00 AM	5:00
2	9:00 PM	12:00 PM	15:00
3	9:00 PM	12:00 AM	3:00
Sheet1

Cell Formulas
Range	Formula
C1	=MOD(B1-A1,1)
C2	=MOD(B2-A2,1)
C3	=MOD(B3-A3,1)