LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mj mj is offline
external usenet poster
 
Posts: 78
Default Adding hours in Excel

Hello
I am trying to create a timesheet which tracks the total hours worked in a
day along with overtime. I don't want to show the lunch break but I want to
factor it in.
ex.
Start 7 AM
End 6 PM
Total Hours 10 Hours (1hr for lunch)

I also want to be able to track the hours per week based on a 50 hr work week.

Any suggestions would be appreciated.

Thanks in advance
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding hours and minutes Breezy77 Excel Discussion (Misc queries) 7 August 3rd 07 02:46 AM
adding hours in excel knee0n Excel Discussion (Misc queries) 3 July 5th 07 11:08 AM
Adding hours to time in Excel [email protected] New Users to Excel 6 May 11th 07 10:50 PM
adding total number of hours in excel? Ramy Excel Worksheet Functions 1 June 30th 06 10:07 PM
Adding time in hours Jono Excel Discussion (Misc queries) 2 September 22nd 05 12:46 PM


All times are GMT +1. The time now is 07:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"