Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting time as text in formula to get sum of cells
I have programmed a spreadsheet to accept daily hours entered in a1 and
summed in b1.... for 6 days. When I try to create a formula to accept total sums of c1,f1,i1,l1 and o1. It will not do so for me. I either get a blank cell or 0.00. I have changed that cell to be a custom of (h):mm:ss, however it still will not total them for me. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting time as text in formula to get sum of cells
Sounds a cell format issue. Try this
Select your range including your addition cell and apply the custom format of hh:mm:ss Enter you time in the format 1:20:25 and then add them up with =Sum(a1:a5) or whatever range they are in. "cnbcheryl" wrote: I have programmed a spreadsheet to accept daily hours entered in a1 and summed in b1.... for 6 days. When I try to create a formula to accept total sums of c1,f1,i1,l1 and o1. It will not do so for me. I either get a blank cell or 0.00. I have changed that cell to be a custom of (h):mm:ss, however it still will not total them for me. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting time as text in formula to get sum of cells
actually I didn't correctly explain my calculation.... a1 has start time of
7:45 AM, b1 has end time of 6:00 PM thus my c1 cell is the sum of those. My weekly total is not working as I am asking it to = sum (c1,f1, etc...) and it is not working as it is telling me it will not read cells that are read as text, which my c1 cell is formatted as in order to read my times and calculate them... I am at a loss and have been unable to figure out how to format the cells to work together....????? "Mike" wrote: Sounds a cell format issue. Try this Select your range including your addition cell and apply the custom format of hh:mm:ss Enter you time in the format 1:20:25 and then add them up with =Sum(a1:a5) or whatever range they are in. "cnbcheryl" wrote: I have programmed a spreadsheet to accept daily hours entered in a1 and summed in b1.... for 6 days. When I try to create a formula to accept total sums of c1,f1,i1,l1 and o1. It will not do so for me. I either get a blank cell or 0.00. I have changed that cell to be a custom of (h):mm:ss, however it still will not total them for me. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting time as text in formula to get sum of cells
Sorry now i understand.
In your addition cell set the custom format of [h]:mm Note thesee are square brackets. Mike "cnbcheryl" wrote: actually I didn't correctly explain my calculation.... a1 has start time of 7:45 AM, b1 has end time of 6:00 PM thus my c1 cell is the sum of those. My weekly total is not working as I am asking it to = sum (c1,f1, etc...) and it is not working as it is telling me it will not read cells that are read as text, which my c1 cell is formatted as in order to read my times and calculate them... I am at a loss and have been unable to figure out how to format the cells to work together....????? "Mike" wrote: Sounds a cell format issue. Try this Select your range including your addition cell and apply the custom format of hh:mm:ss Enter you time in the format 1:20:25 and then add them up with =Sum(a1:a5) or whatever range they are in. "cnbcheryl" wrote: I have programmed a spreadsheet to accept daily hours entered in a1 and summed in b1.... for 6 days. When I try to create a formula to accept total sums of c1,f1,i1,l1 and o1. It will not do so for me. I either get a blank cell or 0.00. I have changed that cell to be a custom of (h):mm:ss, however it still will not total them for me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help converting text to date & time? | Excel Worksheet Functions | |||
Converting time from text to numeric | Excel Worksheet Functions | |||
formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
Converting Text Values to Time | Excel Programming | |||
Converting Text to Time format of XX:XX | Excel Discussion (Misc queries) |