Is there an online or downloadable form that tallies hours worked when you enter time started and finished?

Question

I am looking for an easy spreadsheet where you just enter what time you started and finished work and how long your break was.

Answer 1

You can do this with a simple spreadsheet on your own. Label column 1 as start time, column 2 as break 1 start, column 3 as break 1 end, column 4 as lunch start, column 5 as lunch end, column 6 as break 2 start, column 7 as break 2 end, and column 8 as end time. Select all 8 columns and format them as cell type "time". Finally in column 9 in the second row, add the formula:
'=(B2 - B1) + (B4 - B3) + (B6 - B5) + (B8 - B7).

Cut and paste the formula from the second row into each of the subsequent rows and the row designation should change automatically.

Change the sequence of the breaks and lunch if your typical day is different, and if you get paid for the breaks you can leave out those columns or leave them blank - and of course change the formula accordingly.

If you want to build the time card as a series of rows instead of a single column, so that you have more flexible start and stop sequences for break and lunch, just create a bunch of rows where the first column is start and the second column is stop and make the third column with the formula '= B2 - B1 (where the letter changes for each row), and then at the bottom sum all the sub-totals in the third column. The sum total will be your total work hours. Again, if you get paid for your breaks, don't record a start and stop time for those.

Answer 2

I use to work as a billing clerk and can send you the spreadsheet we use to bill our tech. I still have the template if you want it I can send it to you right now. However, it is in military time so 1pm would be 13:00 and so on.