Time sheet

[Ed Davis]

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

 

[Gord Dibben]

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

 

[T. Valko]

a 3 would total hours/min should be 6:00

The correct result should be 11:00.

It would be much easier for you if you used this layout:

...........A..........B..........C.............D
1........In........Out......Total......Grand Total
2......13:45...00:45....11:00.........16:05
3.......8:25....13:30......5:05

Enter this formula in C2:

=IF(B2="",0,B2-A2+(B2<A2))

Copy down as needed. Format the cell as h:mm

For the Grand Total:

=SUM(C:C)

Format the cell as [h]:mm

Biff