IF results not included in SUM

  • Thread starter Thread starter Lorrie
  • Start date Start date
L

Lorrie

Help:
I don't seem to be able to get this correct.
This is a time card and these column represent the
columns that total the hours.
A- is simply a SUM and works correctly and totals
correctly at the bottom.
Both column B & C are the results of an IF function (i.e.
if Col A is greater then 7:30 then enter 7:30, if not
enter Col A). Col C is IF Col A is greater then 7:30,
enter the difference between 7:30 and 8:00. As you can
see the TRUE entries are not included in the totals at
the bottom. They are all formatted [h}:mm. I don't know
how to get totals correct. Can you help.


-A- -B- -C-
Total REGULAR
hours HOURS
12:30 7:30 :30
4:30 4:30
8:00 7:30 :30
12:00 7:30 :30
3:45 3:45
8:30 7:30 :30
2:45 2:45

52:00 11:00 0:00
 
Lorrie said:
Help:
I don't seem to be able to get this correct.
This is a time card and these column represent the
columns that total the hours.
A- is simply a SUM and works correctly and totals
correctly at the bottom.
Both column B & C are the results of an IF function (i.e.
if Col A is greater then 7:30 then enter 7:30, if not
enter Col A). Col C is IF Col A is greater then 7:30,
enter the difference between 7:30 and 8:00. As you can
see the TRUE entries are not included in the totals at
the bottom. They are all formatted [h}:mm. I don't know
how to get totals correct. Can you help.


-A- -B- -C-
Total REGULAR
hours HOURS
12:30 7:30 :30
4:30 4:30
8:00 7:30 :30
12:00 7:30 :30
3:45 3:45
8:30 7:30 :30
2:45 2:45

52:00 11:00 0:00
Click to expand...

Lorrie,

It works fine for me, I get 52:00, 41:00 and 2:00. What formulae do you have
in B amd C?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top