Calculate employee hours worked using Excel?

• by Dennis Faas on 20041123 @ 08:05PM EST | google it | send to friends
• Filed under Technology | Science | (related terms: convert, week, example, card, hourly wage)

Infopackets Gazette Reader Katia E. writes:

" Hi Dennis!

I need your help in solving a little dilemma. I created a simple Excel spreadsheet to calculate the employee work hours from a time card. The problem is that I just cannot find a formula that will add the total hours worked everyday, in order to get a total of hours worked for the week.

For example, the time card contains the following information: SAT --, SUN --, MON 8:31am, TUE 8:33am, WED 8:43am, THU 8:12am, FRI 9:00am. Any help you can give me to leave this frustration behind is greatly appreciated! "

My response:

This is actually a very common 'computer science' problem, and can be easily solved by standardizing the base unit of time. One approach you can use is to convert hours into minutes, add up the total minutes, convert the total back into hours, and then multiply the hours by the hourly wage.

For example:

32 hours and 15 minutes worked for the week = (32 hours x 60 minutes) + 15 minutes = 1935 minutes total

To convert the total minutes into hours: = (1935 minutes / 60) = 32.25 total hours worked

To figure out the pay check (based on an hourly wage): = 32.25 hours x Rate of Pay = your check

Free eBook: Windows 7: Tips & Tricks. This eBook is for users that want to go one step further in their understanding of the Windows 7 operating system. With over 50 of the finest tips and tricks, this 113 page Windows 7 eBook features a plethora of screenshots, and was written especially for novices in mind. Also included is a bonus section for Windows 7 applications. Written and presented by technology enthusiast Vasu Jain. About the author: Vasu Jain is a software developer, web engineer, blogger, and Master's student at University of Southern California. He has written 2 other eBooks, including Office 2010 Tips & Tricks, and Developing apps for Windows 8. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.

---