Hi All
Thanks for taking the time to read this, hopefully someone can point me in the right direction am going mad with this problem.
I am trying to build a timesheet which is doing what I want other than none of my formulas now work.
Originally I set it all up with Validation Lists but as the lists are so long the users found to much scrolling was required.
Since then I have set up Active X Combo Boxes for Task Diversion and Time.
None of the "SUM" Formulas are working any more, what do I need to do now the data is in Combo Boxes?
There is a Time Combo Box in each cell in the range C5:C29 each one is linked to it's relative cell, so when the time is submitted it writes to file "Database". All this is working fine and values are copied over.
I don't need any totals copied to another file I just want them to show in the Timesheet.
The formulas that I had originally working are as follows:
Total (min per day)
=SUMIF(F5:F29,"Saturday",C5:C29)
Total Time Submitted (Mins)
=SUM(C5:C29)
Time In Hours
=SUM(E30/60)
I have added a copy of the Timesheet, any help greatly appreciated (I have never used formulas in VBA).
Bookmarks