Excel Pro Tips
Excel Formula to Calculate Hours Worked Minus Lunch
Learn simple Excel methods to calculate hours worked minus lunch using SUM, MOD, direct subtraction, and format results in hours and minutes.
Read article
Author & Spreadsheet Consultant
Tasmia Rahim
268 Articles PublishedPublishing since
Tasmia Rahim holds a B.Sc in Electrical Engineering with a focus on automation and embedded systems, supporting logic-driven spreadsheet workflows. With 2 years of Excel and Google Sheets experience, she works with conditional formatting and basic automation. She is interested in using macros and ActiveX controls to simplify Excel tasks and improve usability.
Editorial Review
Articles Published by Tasmia Rahim
Articles by Tasmia Rahim are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel Pro Tips
How to Calculate Elapsed Time Between Two Dates in Excel
Learn how to calculate elapsed time between two dates in Excel using subtraction, DATEDIF, NETWORKDAYS, and unit conversions.
Read article
Excel Pro Tips
How to Calculate Cycle Time in Excel (8 Different Examples)
Learn how to calculate cycle time in Excel using subtraction, MOD, and unit-based formulas for minutes, seconds, and hours accurately.
Read article
Excel Pro Tips
How to Calculate Remaining Days in Excel (5 Formulas)
Learn how to calculate remaining days in Excel using MAX, DAYS, EOMONTH, NETWORKDAYS, and DATE functions for accurate, negative-free results.
Read article
Excel Pro Tips
Excel Conditional Formatting to Highlight Dates Within 30 Days
Learn how to use Excel conditional formatting to highlight dates within 30 days using TODAY and AND for dynamic tracking and accuracy.
Read article
Excel Pro Tips
How to Mirror a Table on Another Sheet in Excel
Learn how to mirror a table on another sheet in Excel using simple formulas, conditional logic, Power Query, and VBA for automatic updates.
Read article
Excel Pro Tips
How to Create a Table from Another Table in Excel
Learn how to create a new Excel table from another table using filtering, INDEX-MATCH, and VLOOKUP to extract and organize data easily.
Read article
Excel Pro Tips
How to Find and Show Comments in Excel (4 Methods)
Learn to find and show comments in Excel using the Review tab, Excel Options, context menus, and easy VBA for automatic comment display.
Read article
Excel Pro Tips
How to Insert Picture in an Excel Comment (with Simple Steps)
Learn how to insert a picture into an Excel comment by creating a comment, accessing Format options, using Fill Effects & finalizing display.
Read article
Excel Pro Tips
How to Convert Comments to Notes in Excel
Learn how to convert Excel comments to notes manually, with a custom UDF, or by running a VBA macro to bulk-convert all comments to notes.
Read article
Excel Pro Tips
How to Import Instagram Comments to Excel
Learn how to export Instagram comments to Excel using online download tools or browser extensions for data collection and analysis.
Read article
Excel Pro Tips
How to Delete Text Box in Excel (3 Simple Ways)
Learn how to delete text boxes in Excel using the Delete key, Go To Special or VBA to automatically clear all text boxes at once.
Read article