Ed

See Chip Pearson's site for working with dates and times.

http://www.cpearson.com/excel/datetime.htm#AddingTimes

Also see his Timesheet page

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


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 20:39:49 -0400, "Ed Davis" wrote:

I have a time sheet with the following information and would like to
calculate total hours.

a1 in at 13:45
a2 out at 00:45
a 3 would total hours/min should be 6:00
then undet that I have the following

a5 in at 08:25
a6 out at 13:30
a7 would total hours/min should be 5:05

then at the bottom I need to total a3 plus a7 and then several others.
This total would be all hours worked on that day. The total could be 35:45
hours

Is it possible?

I figured out how to get the hours worked for a3 and a7 but can not figure
out how to total all hours for a day.



also I would like to