SirJB7
Excel Rōnin
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!
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!