sum and subtract hours
On Feb 4, 4:14 am, "RichardSchollar"
wrote:
Hi
Are these hours in time format in Excel? Something like:
10:00
or some such? If so, the actual number (decimal) that this represents
is actually 10/24 or 0.416667 since hours are stored as the fraction
of a day, and 1.0 = 1 day. Hence, when you attempt to deduct 44
(rather than 44/24) you get ####### as Excel does not handle negative
times.
In which case, you may only have to use the following:
=IF(SUM(H7:H13)44/24,SUM(H7:H13)-44/24,SUM(H7:H13))
Hope thsi helps!
Richard
It Sure does thanks alot
here's what I finished with
=IF(SUM(H7:H13)44/24,SUM(H7:H13)-44/24,0)+IF(SUM(H14:H20)44/24,SUM(H14:H20)-44/24,SUM(H14:H20))
|