Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
laura6201
 
Posts: n/a
Default How do I calculate total weekly hours for payroll in Excel?

I'm having a heck of a time with this...I tried using some of the other
suggestions posted but nothing is working for me.
For each employee I have a start time and an end time (ex: start 8:00 am -
end 2:30 pm). I need to calculate the total hours worked for each employee
weekly. I know there must be a simple formula out there somewhere, please
help me!
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Hi, Laura. Try this:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"laura6201" wrote in message
...
I'm having a heck of a time with this...I tried using some of the other
suggestions posted but nothing is working for me.
For each employee I have a start time and an end time (ex: start 8:00 am -
end 2:30 pm). I need to calculate the total hours worked for each employee
weekly. I know there must be a simple formula out there somewhere, please
help me!



Reply
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 minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? StargateFan Excel Discussion (Misc queries) 8 January 7th 06 07:35 PM
How do I calculate total hours by rate of pay? FrankF Excel Worksheet Functions 1 August 16th 05 11:18 PM
Calculating Overtime from Hours total Dreamweavn via OfficeKB.com Excel Worksheet Functions 6 April 29th 05 11:21 PM
calculate hours just can't figure it out monish74 Excel Worksheet Functions 1 February 13th 05 07:31 PM
calculate difference in time to hours Chris Excel Worksheet Functions 5 January 18th 05 06:07 PM


All times are GMT +1. The time now is 03:01 AM.

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

About Us

"It's about Microsoft Excel"