Timesheet

[Addies17]

I am trying to do a time sheet for work.

Travel time start	Travel time finish	Total travel time	Site start	Site finish	Total site time
7:00	8:00		8:00	9:00
7:15	9:45		9:45	16:00

We use time in 15 minute incriments

2 question which is the best formula for total travel time and total site time?

Also at the bottom I need to add the weeks travel in one coloum, the weeks total site time in another

Then one cell which is the total ((total travel time+total site time)-2.5) The 2.5 hours is for a 30 min daily lunch break

 

[etaf]

travel would be B2-B1 & =E2-D2
Then sum up the totals
BUT make sure you format as [H]:mm so you get over 24 hrs recorded

and the total would be
=C10+F10-2.5/24

Book1
	A	B	C	D	E	F	G	H
1	Travel time start	Travel time finish	Total travel time	Site start	Site finish	Total site time
2	7:00	8:00	1:00	8:00	9:00	1:00
3	7:15	9:45	2:30	9:45	16:00	6:15
4
5
6
7
8
9
10			3:30			7:15		8:15
Sheet1

Cell Formulas
Range	Formula
C2:C3,F2:F3	C2	=B2-A2
C10,F10	C10	=SUM(C2:C9)
H10	H10	=C10+F10-2.5/24

if the work time goes over midnight , will need a different formula

 

[Addies17]

travel would be B2-B1 & =E2-D2
Then sum up the totals
BUT make sure you format as [H]:mm so you get over 24 hrs recorded

and the total would be
=C10+F10-2.5/24

Book1
	A	B	C	D	E	F	G	H
1	Travel time start	Travel time finish	Total travel time	Site start	Site finish	Total site time
2	7:00	8:00	1:00	8:00	9:00	1:00
3	7:15	9:45	2:30	9:45	16:00	6:15
4
5
6
7
8
9
10			3:30			7:15		8:15
Sheet1

Cell Formulas
Range	Formula
C2:C3,F2:F3	C2	=B2-A2
C10,F10	C10	=SUM(C2:C9)
H10	H10	=C10+F10-2.5/24

if the work time goes over midnight , will need a different formula

Generally work doesn’t go over midnight so should be ok. THANK YOU i will try it in work tomorrow

 

[etaf]

you are welcome