Excel time clocke

[twotone73]

I am trying to use excel to do payroll at my store. I would like the cells to be able to recognize the numbers as times so I can keep track of hours? Is there a way to do this?

Thanks
twotone73

 

[joelnichols]

This do the trick?

Book1
	A	B	C	D
1
2		In	Out	Total hours
3
4	John	8:00	16:00	8:00
5	sue	12:00	20:00	8:00
6	Mike	14:00	22:00	8:00
Sheet1

I use format|custom| h:mm on mine.