Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Need template for Drivers Hours Timesheet and Forumula in Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-02-2012
Member
 
Join Date: Jan 2012
Posts: 25
Need template for Drivers Hours Timesheet and Forumula in Excel

I am a lorry driver by trade and wish to create a Timesheet in Excel 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 calculate my daily rest period, (Rest period is calculated from time finished and time started next day) and the total hours that I worked for the week. Can anyone help me please.

Reply With Quote
  #2  
Old 15-02-2012
Member
 
Join Date: Aug 2011
Posts: 564
Re: Need template for Drivers Hours Timesheet and Forumula in Excel

Let's say your start time in A2, and end time in B2 and A3 is your start time on the next day. Try the following =B2-A2 (total work time in that day) =A3-B2+(B2>A3) (total rest time).
Reply With Quote
  #3  
Old 15-02-2012
Member
 
Join Date: Aug 2011
Posts: 690
Re: Need template for Drivers Hours Timesheet and Forumula in Excel

Try the formula. Try this: [hh] "h" mm The [hh] gives you a countdown in hours without 24 hours = 1 day the "h" allows you to have a type display 25h38, mm is the minutes display. To enter a negative time in a cell EXCEL: you must first select "1904" (in Tools / Options / Calculation tab), then give one format to the cell type 'hh: mm' for example, and enter negative time like this - "0:30" for-30minutes
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need template for Drivers Hours Timesheet and Forumula in Excel"
Thread Thread Starter Forum Replies Last Post
Excel 2010 - Timesheet Normal Hours - Help! DMF Windows Software 1 09-02-2012 11:46 PM
Need Rota Template for Microsoft Excel fAlCoNeTtI MS Office Support 3 27-01-2012 04:37 PM
Need excel template for coupon organization in Excel Shaina Na Windows Software 1 06-01-2012 08:31 PM
Is there any football pool template available in Excel Sanju Baba Windows Software 1 06-01-2012 08:22 PM
Calculation of business hours in Excel Jayden Windows Software 3 29-07-2009 08:15 AM


All times are GMT +5.5. The time now is 03:02 AM.