Time sheet entries

[Jeaneb]

How do you add and subtract time entries.
ex: Employee starts at 10:00 am and works until 6:15 pm. Total hours for that day?

 

[plettieri]

Hello Jeaneb and welcome to the board

A little understanding of the way excel handles time is important see ...http://www.ozgrid.com/Excel/ExcelDateandTimes.htm


Are you looking to do something like this...

Format your cells custom h:mm

formular samples.xls
	A	B	C	D	E	F	G
1
2
3
4	Start		10:00
5	Finishtime		18:15
6		diff	8:15
7
8
time ref

hope this helps

pll

 

[Lawnman]

Jeaneb
I just enter times directly.

A1cell- 10:00 am
A2cell- 11:00 am
A3cell- =a2-a1
in cell a3 you may get a decimal # if you do go to cell format and change the cell format
Also make sure you add space between the last # and the AM or PM, or it will not work
Dennis

 

[cblincoln43]

Got e-mail send to cblincoln43@yahoo.com, Will send working time sheet you can work with. OH! lable it time sheet.
Thanks to the fine folks on this board.
Bob, cblincoln
This message was edited by cblincoln43 on 2002-10-13 01:14