Excel: Subtract Minutes from Time

  • [アーティクル]

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: https://aka.ms/leesteve —
If you like my blogs, please share it on social media and/or leave a comment.