Sum Formulas Don't Work With Combo Boxes

[Sabrina68]

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).

[Special-K]

Time In Hours
=SUM(E30/60)

You don't need to SUM this, it is a simple division calculation. No SUMming required.
Change it to

=E30/60

[Sabrina68]

Thanks for that Special K, I will amend the formula
Still can't get any formulas to work at all, I don't think the formulas are reading the values in the combo boxes

[cytop]

I don't think the formulas are reading the values in the combo boxes

They can't. Formulas work with cells, not other controls - even if those controls are 'contained' in a cell. However you can link a combobox to a cell so that cell is updated with the value selected in the combobox. You can apply your formula to those cells no problem.

[Sabrina68]

Thanks for the response Cytop.
I have filled in the Linked Cell field in each Combo Box property
Combo Box 1 is linked to C5, Combo Box 2 is linked to C6 and so on all the way down the column from C5 to C29.
I still can't get the formulas to work in any way
Totally lost what I am doing wrong or what else I need to do to get this working

[Special-K]

The values in column C are not numbers, even when selecting a dropdown value from column C
hence the SUM of C5:C29 is zero.

This works
in E30
=SUMPRODUCT(VALUE(C5:C29))

[cytop]

Whoops - forgot about the 'Text' issue... Apols.

[Sabrina68]

I never thought of the values being entered as text, thanks for pointing that out
So if I change the format of values to number instead of text the formulas should then work?
Do I just change the format in the list source date to number instead of general?