Excel And Adding Up Time

[Wrangler3]

I want to log and track my working hours. I have created a worksheet in which I can enter my start and end times (cells formatted hh:mm) and Excel calculates my daily working hours.

However, when I try and get Excel to total up these hours, using sigma or by manually entering the formula =SUM(A1:A30) for example, the result is spurious.

What am I doing wrong? Thanks for any help :-)

[TheChair]

You'll probably find this example helpful.
http://www.excel-easy.com/examples/time-sheet.html

[CrapAtCryptics]

surely an auto sum with the last cell being the total - I used something similar for many years for hours / leave amd TOIL

[bednobs]

i no next to nothing about excel, but is the total cell also in the right format?

[IggyB]

That should work provided the cell with the formula is also formatted to [h]:mm and the times you record are written as 5:30 rather than 5.30

[Maydup]

As in the linked example, you need to use 24 hr clock, create a column to calculate the hours for each day or shift, and then sum the column.

You could have a new tab for each month perhaps.

[Maydup]

PS think about the formatting. Eg

If you worked until 16:30 there's half an hour to be included but excel will see that as 16.3 of an hour rather than 16.5 of an hour. If that makes sense. 16:15 is .25 of an hour etc.