SUMIF with time
 

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

SUMIF with time
 

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" wrote in message
...
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

SUMIF with time
 

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)


"Bob Phillips" wrote:

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" wrote in message
...
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

SUMIF with time
 

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

"sid6478" wrote in message
...
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)


"Bob Phillips" wrote:

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" wrote in message
...
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

SUMIF with time
 

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

"Roger Govier" wrote:

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

"sid6478" wrote in message
...
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)


"Bob Phillips" wrote:

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" wrote in message
...
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

SUMIF with time
 

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

"sid6478" wrote in message
...
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

"Roger Govier" wrote:

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

"sid6478" wrote in message
...
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)


"Bob Phillips" wrote:

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" wrote in message
...
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