Add timecard

I am adding time for a service tech who makes several stops per day. I have the spreadsheet calculating the time, but do not know how to total this in order to have the total time for the day.

You don't have to format the calculation to show the time difference, you can format you cell to show the difference. Then you only need to add up the times.



I've attached an example.

Thanks so much. I guess my thinking was muddled trying to calculate hours and minutes. Because the first two columns are formatted as times, the grand total will calulate as correct hours and minutes. Is this right?

You'll have to format them as times. Sometimes Excel is helpful and assigns the same formats, sometimes it is not. Best to be on the safe side and format them yourself. The custom format I used was [hh]:mm. The brackets forces Excel to accumulate past 24 hours instead of rolling over after 24 hours.