Excel 2010 formating / sumation issues

Closed
Tim - Oct 3, 2012 at 03:00 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Oct 4, 2012 at 05:30 AM
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
Related:

1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Oct 4, 2012 at 05:30 AM
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.

0