Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I'm trying to add time entries using the SUM formula but I get blanks as the result. My columns are about 20 cells long and contain anywhere from 1 to 20 entries at anyone time. I formatted all cells using [h]:mm:ss and it still comes up blank. Here's what I'm working with: Date Total time 10/1/2008 4:36:33 10/2/2008 4:58:51 10/3/2008 10/6/2008 10/7/2008 10/8/2008 etc. I want to sum up the "Total time" column. I used the following formula but get nothing but a blank cell: =SUM(E217:E218) Thanks, Marta |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding time | Excel Worksheet Functions | |||
Adding time | Excel Worksheet Functions | |||
Adding Time | Excel Worksheet Functions | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |