Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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+(B2>A3) (total rest time)
 
....and for total weekly hours just sum your daily hours andd format result
cell as [h]:mm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating automated timesheets 2
24 Hour Format For Timesheet 3
Work hours with overtime 2
Creating a Complex Timesheet Record 1
Cumulative Timesheet Entries 5
Timesheets 2
Working hours 4
Timesheet - convert time format 4

Back
Top