I tossed this together because I wasn’t happy with the time sheet I have in Excel. Just a simple time sheet for people that have flex time and/or overtime at work.
Enjoy!
I tossed this together because I wasn’t happy with the time sheet I have in Excel. Just a simple time sheet for people that have flex time and/or overtime at work.
Enjoy!
@Thomas_M, Thanks sharing your work, always open to learn
Best regards,
@Jean_Pierre_Traets
No problem! I wouldn’t mind any suggestions that you might have, either!
Hi Thomas, quite impressive how you designed the structure to reach the final result.
There is something wrong with the difference column.
I assume that the number needs to be converted to minutes.
For example when I see that I have 30 minutes difference, it displays 0.50 what means 1/2 hours = 30 minutes.
This on a mobile app would be a great tool for small companies
There are interesting IF statements, something I am trying to catch up with.
Thanks sharing the template
@Jean_Pierre_Traets
Yes, the difference column is on purpose since most payroll departments don’t need to see the hours and minutes, but rather the hours and the decimals.
Hi @Thomas_M - would you mind going into google drive and changing the sharing settings to - anyone with a link can view. I want to take a look but don’t have access.
Sure! That makes my life easier.