Excel 2010 formating / sumation issues Closed

Question

Hi

I've got an Excel 2010 issue and I can't seem to find the answer  any where.
I'm generating a spread sheet from a C# application which displays employees attendance.

For example I have number of hours worked in column "E" where I have the values 40:00 40:00 50:00 60:00.

The column cells have the format of [h]:mm 

If I do SUM(E2:E5) I get 00:00 (incorrect) but if I do E2 + E3 + E4 + E5 I get the correct answer of 190:00

Any help would be very much apriciated

Tim

Zohaib R · Answer

Hi Tim,

You can add times using the =SUM worksheet function. Just enter all of your times as HH:MM:SS, and then use SUM to add them up.
Also, like you mentioned the excel file is connected programmatically to C#, ensure the time is entered in the correct format and not as a text string.

Please revert for clarification.

Excel 2010 formating / sumation issues

1 response

Similar discussions

Subscribe To Our Newsletter!