So, you have a spreadsheet and you're trying to log time entries, say for work. You work 8:00 to 4:30 and get a half hour for lunch. How do you calculate this in Excel?

1. Create a spreadsheet, and put this in column A: 8:00:00 AM

2. Put this in Column B: 4:30:00 PM

3. Format columns A, B, and C to a time column.

4. Then, add this formula to Column C:

**((B1-A1)*24*60)-30)/60/24)**

Notice that column C is now at 8 hours, which is the difference in A and B, less a half hour (obviously the -30 in the formula does this). If you don't want to do lunch, then fine, I won't make you. Just omit it from the formula.

— Easy link to my blog: **http://aka.ms/leesteve** —

If you like my blogs, please share it on social media and/or leave a comment.