Time Card calculations with excel [SOLVED]

[SirJB7]

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!

 

[ChuckVaughan]

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

 

[SirJB7]

Hi, ChuckVaughan!

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

Regards!