Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing cells defined as Time hh:mm
I looked at a couple of similar questions but have not been able to achieve a
good result. I have a few cells defined as Time HH:MM. I want to sum them up so I get hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)". I formatted the Total cell as custom with a format of [hh]:mm. The original values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I am getting is 577:00 Which is funny, but not very useful. Can you help, Ed |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing cells defined as Time hh:mm
Make sure you don't have an AM/PM problem. If you format your cells as
General you should see: 0.416666667 0.125 0.5 1.041666667 -- Gary''s Student "Ed H" wrote: I looked at a couple of similar questions but have not been able to achieve a good result. I have a few cells defined as Time HH:MM. I want to sum them up so I get hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)". I formatted the Total cell as custom with a format of [hh]:mm. The original values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I am getting is 577:00 Which is funny, but not very useful. Can you help, Ed |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing cells defined as Time hh:mm
"Ed H" wrote in message
... I looked at a couple of similar questions but have not been able to achieve a good result. I have a few cells defined as Time HH:MM. I want to sum them up so I get hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)". I formatted the Total cell as custom with a format of [hh]:mm. The original values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I am getting is 577:00 What values are in the other 2 cells? N43 to N47 are 5 cells; you've quoted 3 values. Are the other 2 empty? -- David Biddulph |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing cells defined as Time hh:mm
They are indeed empty.
"David Biddulph" wrote: "Ed H" wrote in message ... I looked at a couple of similar questions but have not been able to achieve a good result. I have a few cells defined as Time HH:MM. I want to sum them up so I get hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)". I formatted the Total cell as custom with a format of [hh]:mm. The original values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I am getting is 577:00 What values are in the other 2 cells? N43 to N47 are 5 cells; you've quoted 3 values. Are the other 2 empty? -- David Biddulph |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing cells defined as Time hh:mm
Set them to 0:00 with no difference. Also set them to 1:00 with no difference.
"David Biddulph" wrote: "Ed H" wrote in message ... I looked at a couple of similar questions but have not been able to achieve a good result. I have a few cells defined as Time HH:MM. I want to sum them up so I get hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)". I formatted the Total cell as custom with a format of [hh]:mm. The original values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I am getting is 577:00 What values are in the other 2 cells? N43 to N47 are 5 cells; you've quoted 3 values. Are the other 2 empty? -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grand total time between two total cells | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How to chnge 35 relative cells to 35 absolute cells at one time. | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
split combined Time Date cells | Excel Discussion (Misc queries) |