Excel 2010 formating / sumation issues

[Closed]
Report
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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

1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
45
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.