• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Time Card calculations with excel [SOLVED]

Hi, ChuckVaughan!


Give a look at this file:

https://dl.dropboxusercontent.com/u/60558749/Time%20Card%20calculations%20with%20excel%20-%20TIMESHEET%20TRACKING%20%281%29%20%28for%20ChuckVaughan%20at%20chandoo.org%29.xlsm


It has the modifications specified regarding:

a) variable configuration of shifts, hours, and percentages

b) military time format for entering time in and time out

c) automatic calculation of accumulated of hours per percentage type

d) payment calculation based on hourly rate

e) rounding or truncating feature


I converted it from a .xlsx file (normal Excel) to .xlsm file(Excel with macros), so as to provide you the functionality of: clearing a time card, printing it, and hiding/showing the helper and configuration columns.


Just advise if any issue.


Regards!
 
I would like to say thank you to Sir JB7 (Pablo) for such a wonderful spreadsheet. Pablo is a very kind and giving person that is a master at excel spreadsheets. You are a genius my friend.


Chandoo. org is the best site ever for assistance in solving your spreadsheet issues.


Thanks so much, Chuck
 
Hi, ChuckVaughan!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!
 
Back
Top