Properly Count time in Excel

Hi Fellas, I'm trying to create an Excel workbook that will track the working hours of everyday, and in the end of the month could tell you how many hours you've worked, How many sick days,, how manmy days yoiu worked from home / out of office work ETC.

My current issue, is that I can't properly sum the hours at the end of the month (Please see attached file for example)
For those of you wondering what's with the "helping sheet" it's for people who' have their system set to Hebrew, so the B colomn would display the name wrong.

The problem is evident on Cell E34.
Any ideas would be greatly appreciated.
timetable.xlsx
LVL 8
David SankovskySenior SysAdminAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
Change the number format from

h:mm

to

[h]:mm
0
 
Rgonzo1971Commented:
No Attachment
1
 
David SankovskySenior SysAdminAuthor Commented:
My apologies, File is attached now
0
 
David SankovskySenior SysAdminAuthor Commented:
Short, succinct and absolutely correct!

Thank you very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.