Tracking time

[lionstud31]

Is there a formula that can calculate my time at work.
column A is arrival time. B is the time I leave for Lunch. C is time I get back from lunch. And D is the time I leave work. Is there a formula I can use to make it calculate it to the nearest hundreth

 

[Brian from Maui]

See,

http://www.cpearson.com/excel/overtime.htm

 

[Macropheliac]

Assuming your ranges are in columns A1,B1,C1,D1 and your result is in column E1.

Format each cell as Time 13:30 and paste into E1:

=D1-A1-(C1-B1)

 

[A1058]

seems too easy?? put total hours in column E format the row that will contain results to time format like hh:mm:ss total hours = finish time-start time-(endlunch-startlunchtime) if the result would ever be more than 24 hours worked the format hh:mm:ss would roll over its limited to 24 hour clock but you could choose time format and pick the one from list that shows 37:30:55 or something like this. most ppl wont work so many hours though.