Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif a date time colum and information | Excel Discussion (Misc queries) | |||
Why won't the SUMIF function in Excel add time? | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |