Can't sum hh:mm - automated report from system

[stuckperson1]

Hello,

I run an automated report from a system and provides me data. One column is in general format and contains hours and minutes.

When I select these cells it only counts the number of cells. I need to count the hours and minutes. When I click into the cell and press enter, then it will sum the hours.

I have tried changing the format to custom and entering hh:mm and other variations but it doesn't change anything.

Any ideas?

 

[stuckperson1]

Just some more info, once I click into the cell and press enter, when it then allows me to sum...the format changes to custom and shows as hh:mm in the cell format.

 

[billszysz]

I do not see Your data...... but try this one

SUM(--(A1:A100))

where A1:A100 is your range to sum
Of course, You have to change the cell format to [gg]:mm

 

[billszysz]

If you want to change all cells in your range then type 1 in a cell outside your range Then select this cell and CTRL+C.
Next select your range to change it and Paste Special --> multiply

 

[stuckperson1]

I do not see Your data...... but try this one

SUM(--(A1:A100))

where A1:A100 is your range to sum
Of course, You have to change the cell format to [gg]:mm

Thanks,

This doesn't help me much. It works, but I need to put my data in a pivot table and I often need to just quickly select cells to sum up hours of certain lines.

 

[stuckperson1]

If you want to change all cells in your range then type 1 in a cell outside your range Then select this cell and CTRL+C.
Next select your range to change it and Paste Special --> multiply

This gives me decimals which I then need to multiply by 24 to get hours. But it's still in decimals. I am used to hh:mm

 

[billszysz]

Time is decimal in excel.
See my first post here

Of course, You have to change the cell format to [gg]:mm