StacyRenee79
New Member
- Joined
- Feb 15, 2002
- Messages
- 5
I've been trying to create a formula to add my drivers hours. I enter them by
day, and need a total for the week.
Here is how they are keyed in:
Monday Tuesday WednesdayThursday Friday TOTAL
9.50 9.50 8.15 9.23 8.50 6.08
Now when adding these times, if two times added together equal or go over 60
then I have to add 40.
Example 9.50 + 9.50 = 1900 "but I need to add 40" so my total should be 19.40
Same with 9.23 + 9.40 = 18.63 "but I need to add 40" so my total should be 19.03
But with 8.15 + 8.15 = 16.30 then that's fine
I have a formula that works but it will not return my FALSE value. Here is the
formula I have:
=IF(SUM(A1:B1)>0.6,SUM(A1:B1)+.40,SUM(A1:B1))
I've probably got you all confused, I know I am.
Is there something wrong with that formula?
Can you help???
day, and need a total for the week.
Here is how they are keyed in:
Monday Tuesday WednesdayThursday Friday TOTAL
9.50 9.50 8.15 9.23 8.50 6.08
Now when adding these times, if two times added together equal or go over 60
then I have to add 40.
Example 9.50 + 9.50 = 1900 "but I need to add 40" so my total should be 19.40
Same with 9.23 + 9.40 = 18.63 "but I need to add 40" so my total should be 19.03
But with 8.15 + 8.15 = 16.30 then that's fine
I have a formula that works but it will not return my FALSE value. Here is the
formula I have:
=IF(SUM(A1:B1)>0.6,SUM(A1:B1)+.40,SUM(A1:B1))
I've probably got you all confused, I know I am.
Is there something wrong with that formula?
Can you help???