SUMIF with time

[sid6478]

I need to be able to add certain cells in certain collums by a code i can get
it to do it with normal numbers but not when i try to add hours and minutes

 

[Bob Phillips]

Maybe it is just overspill, format the target cell as [h]:mm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[sid6478]

Hi sorry did not make my self very clear I'm trying to add time durations
filterd by codes to a total

A B C D
1 C 13:30 14:00 00:30
2 Br 14:00 14:30 00:30
3 C 14:30 15:30 01:00
4
5 C 01:30
6 Br 00:30

I've tried =sumif(a1:a3,"C",d1:d3)

Maybe it is just overspill, format the target cell as [h]:mm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I need to be able to add certain cells in certain collums by a code i can
get
it to do it with normal numbers but not when i try to add hours and
minutes

 

[Roger Govier]

As Bob says, just format the cell with the formula.
Without formatting it will show 0.0625
Once you format, you will see 1:30
--
Regards
Roger Govier

Hi sorry did not make my self very clear I'm trying to add time durations
filterd by codes to a total

A B C D
1 C 13:30 14:00 00:30
2 Br 14:00 14:30 00:30
3 C 14:30 15:30 01:00
4
5 C 01:30
6 Br 00:30

I've tried =sumif(a1:a3,"C",d1:d3)

Maybe it is just overspill, format the target cell as [h]:mm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

I need to be able to add certain cells in certain collums by a code i
can
get
it to do it with normal numbers but not when i try to add hours and
minutes

 

[sid6478]

i had it formated to hh:mm through the format cells custom option the cell
its going in is also very large it just returns the result 00:00 is this what
you guys ment if not how else can i format it to [h]:mm.

thanks in advance & so far

As Bob says, just format the cell with the formula.
Without formatting it will show 0.0625
Once you format, you will see 1:30
--
Regards
Roger Govier

Hi sorry did not make my self very clear I'm trying to add time durations
filterd by codes to a total

A B C D
1 C 13:30 14:00 00:30
2 Br 14:00 14:30 00:30
3 C 14:30 15:30 01:00
4
5 C 01:30
6 Br 00:30

I've tried =sumif(a1:a3,"C",d1:d3)

Maybe it is just overspill, format the target cell as [h]:mm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

I need to be able to add certain cells in certain collums by a code i
can
get
it to do it with normal numbers but not when i try to add hours and
minutes

 

[David Biddulph]

You ought to format to [h]:mm, not hh:mm, but if you are getting a zero
result it sounds as if your input cells may have been text, rather than
times.
If you format the cells (either total or input cells) to number, do you see
something non-zero?
--
David Biddulph

i had it formated to hh:mm through the format cells custom option the cell
its going in is also very large it just returns the result 00:00 is this
what
you guys ment if not how else can i format it to [h]:mm.

thanks in advance & so far

As Bob says, just format the cell with the formula.
Without formatting it will show 0.0625
Once you format, you will see 1:30
--
Regards
Roger Govier

Hi sorry did not make my self very clear I'm trying to add time
durations
filterd by codes to a total

A B C D
1 C 13:30 14:00 00:30
2 Br 14:00 14:30 00:30
3 C 14:30 15:30 01:00
4
5 C 01:30
6 Br 00:30

I've tried =sumif(a1:a3,"C",d1:d3)


:

Maybe it is just overspill, format the target cell as [h]:mm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

I need to be able to add certain cells in certain collums by a code i
can
get
it to do it with normal numbers but not when i try to add hours and
minutes