| 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. |
| 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) | |||
Threaded Mode
