View Single Post
 
Old 10-11-2015, 10:44 AM
Fantabulator Fantabulator is offline Windows 10 Office 2013
Novice
 
Join Date: Oct 2015
Posts: 1
Fantabulator is on a distinguished road
Default Can't figure out formula problem using form controls

Hello all,

I am trying to create a log sheet that students will be able to use on their phones. I want to tabulate their daily total of hours and then add all daily totals to give them a weekly total.

To figure out the daily, I designate

Monf( Monday finish)-
Mons( Monday start time)= mtotal
(this one works fine)

When I try to use a form control calculation to calculate the following:

=mtotal+ttotal+wtotal+thtotal+fritotal

the number is all screwed up. Is what I am doing possible? I know it is because I have seen it on other forms.

I can't figure out if I am doing something wrong with my formula.
Reply With Quote