Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis
I am a lorry driver by trade and wish to create a Timesheet in Exel 2002. My
problem is that I although I can calculate the hours that I have worked on a daily basis, I cannot find or work out a formula that will calaculate my daily rest period, (Rest period is calaculated from time finished and time started next day) and the total hours that I worked for the week. Can anyone help me please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis
Let's say your start time in A2, and end time in B2 and A3 is your start time
on the next day. =B2-A2 (total work time in that day) =A3-B2+(B2A3) (total rest time) "Graham" wrote: I am a lorry driver by trade and wish to create a Timesheet in Exel 2002. My problem is that I although I can calculate the hours that I have worked on a daily basis, I cannot find or work out a formula that will calaculate my daily rest period, (Rest period is calaculated from time finished and time started next day) and the total hours that I worked for the week. Can anyone help me please? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Bas
....and for total weekly hours just sum your daily hours andd format result
cell as [h]:mm "Teethless mama" wrote: Let's say your start time in A2, and end time in B2 and A3 is your start time on the next day. =B2-A2 (total work time in that day) =A3-B2+(B2A3) (total rest time) "Graham" wrote: I am a lorry driver by trade and wish to create a Timesheet in Exel 2002. My problem is that I although I can calculate the hours that I have worked on a daily basis, I cannot find or work out a formula that will calaculate my daily rest period, (Rest period is calaculated from time finished and time started next day) and the total hours that I worked for the week. Can anyone help me please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarize employee attendance data on a weekly basis | Excel Worksheet Functions | |||
CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions |