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