Hello Forum,
There is a xlxs worksheet attachment that I couldn't figure out how to do. We have a monthly schedule, three persons Staff 1/2/3. I'd like to calculate total working hours a month to the daily working hours, but I couldn't handle it anyhow. A help would highly be appreciated.
Thank you.
The following function should do it.
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
Or you could use worksheet functions. for instance array formula (committed with Ctrl+Shift+Enter) for first days of staff1
Formula:
Please Login or Register to view this content.
Of course all hours for your staff1 would be (again - it is array formula):
Formula:Please Login or Register to view this content.
Best Regards,
Kaper
Hi pjwhitfield,
I am so glad for the solution you offered me. However, If you told me how to apply in the sheet, I would be really appreciated for this.
Thank you so much Kaper for this even you arranged it for me. That was exactly what I was looking for. Thank you very much again.
Add the code into a Module within your VBA (Alt-F11, then Insert>Module and then Paste code in. Then use it as any other function...eg:Originally Posted by bluecost
=Total_Hours("A1:O1")
I put your VBA as you directed, after that saved in macro-free version. I applied this =Total_Hours("B3:O3") for Staff 1, but I got a value error, pjwhitfield.
The secrets in the words "Macro-free version", it needs to be saved in a Macro worksheet
It is my mistake pjwhitfield; I already saved it as xls, and didn't work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks