| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Times
I am trying to Sum times...
10:00 10:00 10:00 The programing I have used is =SUMIF(B1:B31,"0") It seems to work, however when the Sum comes up it shows 6:00 Not 30:00. I have been working with the formating of the time cells as well, but get very strange amounts when I change hh:mm to [h]:mm. Can someone please help. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum Times
[h]:mm will return 30:00. If you get very strange amounts then you probably
have something else than 10:00 in your cell(s). 34:00 perhaps ? <g HTH. Best wishes Harald "Frank" skrev i melding ... I am trying to Sum times... 10:00 10:00 10:00 The programing I have used is =SUMIF(B1:B31,"0") It seems to work, however when the Sum comes up it shows 6:00 Not 30:00. I have been working with the formating of the time cells as well, but get very strange amounts when I change hh:mm to [h]:mm. Can someone please help. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum Times
one way
=SUMIF(B1:B31,"0")*24 format as general or number -- Greetings from New Zealand Bill K "Frank" wrote in message ... I am trying to Sum times... 10:00 10:00 10:00 The programing I have used is =SUMIF(B1:B31,"0") It seems to work, however when the Sum comes up it shows 6:00 Not 30:00. I have been working with the formating of the time cells as well, but get very strange amounts when I change hh:mm to [h]:mm. Can someone please help. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate times between dates and times in Excel | Excel Discussion (Misc queries) | |||
| count text appear how many times & put in respec col??eg 1st times | Excel Discussion (Misc queries) | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Linear Mode
