---
title: Tips and Tricks for Date/Time Data
description: Tips and Tricks for Date/Time Data
image: https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/date-time-animated-worksheet-Jul-05-2025-11-37-51-3526-PM.gif
---
English
- [English](https://blog.minitab.com/en/?hsLang=en)
- [Français](https://blog.minitab.com/fr/?hsLang=en)
- [Deutsch](https://blog.minitab.com/de/?hsLang=en)
- [Português](https://blog.minitab.com/pt/?hsLang=en)
- [Español](https://blog.minitab.com/es/?hsLang=en)
- [日本語](https://blog.minitab.com/ja/?hsLang=en)
- [한국어](https://blog.minitab.com/ko/?hsLang=en)
- [中文（简体）](https://blog.minitab.com/zh/?hsLang=en)
- [English](https://blog.minitab.com/en/blog/quality-data-analysis-and-statistics/tips-and-tricks-for-date-and-time-data)
- [Chinese](https://blog.minitab.com/zh/blog/quality-data-analysis-and-statistics/tips-and-tricks-for-date-and-time-data)
- [Deutsch](https://blog.minitab.com/de/blog/tipps-tricks-fur-datums-uhrzeitdaten)
- [Español](https://blog.minitab.com/es/blog/consejos-y-trucos-para-los-datos-de-fecha-hora)
- [Français](https://blog.minitab.com/fr/blog/conseils-et-astuces-pour-les-donnees-de-date/heure)
- [Português](https://blog.minitab.com/pt/blog/dicas-truques-para-dados-data-hora)
- [한국어](https://blog.minitab.com/ko/blog/quality-data-analysis-and-statistics/tips-and-tricks-for-date-and-time-data)
- [日本語](https://blog.minitab.com/ja/blog/quality-data-analysis-and-statistics/tips-and-tricks-for-date-and-time-data)
- [ Partners](https://www.minitab.com/en-us/company/partners/)
- [ Contact](https://www.minitab.com/en-us/company/contact-us/)
- [ Talk to Minitab](https://www.minitab.com/en-us/talk-to-minitab/)
- [ My Account](https://licensing.minitab.com/account/manage)
[](https://www.minitab.com/en-us/)
- Products
Back
[Products](https://www.minitab.com/en-us/products/)
[All Products](https://www.minitab.com/en-us/products/)
- [Minitab Solution Center](https://www.minitab.com/en-us/products/minitab-solution-center/)
- [Minitab Statistical Software](https://www.minitab.com/en-us/products/minitab/)
- [Minitab Connect](https://www.minitab.com/en-us/products/connect/)
- [Minitab Model Ops](https://www.minitab.com/en-us/products/model-ops/)
- [Minitab Education Hub](https://www.minitab.com/en-us/products/education-hub/)
- [Minitab Engage](https://www.minitab.com/en-us/products/engage/)
- [Minitab Workspace](https://www.minitab.com/en-us/products/workspace/)
- [Real-Time SPC](https://www.minitab.com/en-us/products/real-time-spc/)
- [Prolink Data Collection & SPC](https://www.minitab.com/en-us/products/prolink)
- [Simul8 Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [SPM](https://www.minitab.com/en-us/products/spm/)
- Solutions
Back
[Solutions](https://www.minitab.com/en-us/solutions/)
[All Solutions](https://www.minitab.com/en-us/solutions/)
- [Analytics](https://www.minitab.com/en-us/solutions/analytics/)
- [Statistics & Predictive Analytics](https://www.minitab.com/en-us/solutions/analytics/statistical-analysis-predictive-analytics/)
- [Data Science & Machine Learning](https://www.minitab.com/en-us/solutions/analytics/data-science-machine-learning/)
- [Business Analytics & Intelligence](https://www.minitab.com/en-us/solutions/analytics/business-analytics-intelligence/)
- [Statistical Process Control](https://www.minitab.com/en-us/solutions/analytics/statistical-process-control/)
- [Quality Analytics](https://www.minitab.com/en-us/solutions/analytics/quality-analytics/)
- [Live Analytics](https://www.minitab.com/en-us/solutions/analytics/live-analytics/)
- [Reliability & Life Data Analysis](https://www.minitab.com/en-us/solutions/analytics/reliability/)
- [Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [Process Mining](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [Key Capabilities](https://www.minitab.com/en-us/solutions/key-capabilities/)
- [Continuous Improvement](https://www.minitab.com/en-us/solutions/key-capabilities/continuous-improvement/)
- [Data Integration & Data Prep](https://www.minitab.com/en-us/solutions/key-capabilities/data-integration-data-prep/)
- [Diagramming & Mind Mapping](https://www.minitab.com/en-us/solutions/key-capabilities/diagramming-mind-mapping/)
- [Digital Twins](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [Model Deployment & ML Ops](https://www.minitab.com/en-us/solutions/key-capabilities/model-deployment-ml-ops/)
- [Innovation & Project Management](https://www.minitab.com/en-us/solutions/key-capabilities/innovation-project-management/)
- [Process Excellence: Detect, Correct & Prevent](https://www.minitab.com/en-us/solutions/key-capabilities/process-excellence/)
- [Featured Industries](https://www.minitab.com/en-us/solutions/industry/)
- [Academic](https://www.minitab.com/en-us/solutions/industry/academic/)
- [Energy & Natural Resources](https://www.minitab.com/en-us/solutions/industry/energy-resources/)
- [Government & Public Sector](https://www.minitab.com/en-us/solutions/industry/government/)
- [Healthcare](https://www.minitab.com/en-us/solutions/industry/healthcare/)
- [Insurance](https://www.minitab.com/en-us/solutions/industry/insurance/)
- [Manufacturing & Industrial](https://www.minitab.com/en-us/solutions/industry/manufacturing-industrial/)
- [Services](https://www.minitab.com/en-us/solutions/industry/service-industries/)
- [Software & Technology](https://www.minitab.com/en-us/solutions/industry/software-technology/)
- [Construction](https://www.minitab.com/en-us/solutions/industry/construction/)
- [Featured Roles](https://www.minitab.com/en-us/solutions/role/)
- [Engineering](https://www.minitab.com/en-us/solutions/role/engineering/)
- [Business Analysis](https://www.minitab.com/en-us/solutions/role/business-analysts/)
- [Information Technology](https://www.minitab.com/en-us/solutions/role/information-technology/)
- [Supply Chain](https://www.minitab.com/en-us/solutions/role/supply-chain/)
- [Customer Service & Contact Center](https://www.minitab.com/en-us/solutions/role/customer-service-contact-center/)
- [Human Resources](https://www.minitab.com/en-us/solutions/role/human-resources/)
- [Marketing](https://www.minitab.com/en-us/solutions/role/marketing/)
- [Research and Development](https://www.minitab.com/en-us/solutions/role/research-and-development/)
- Resources & Services
Back
[Resources & Services](https://www.minitab.com/en-us/resources-services/)
[All Resources & Services](https://www.minitab.com/en-us/resources-services/)
- [Resources](https://www.minitab.com/en-us/resources-services/resources/)
- [Case Studies](https://www.minitab.com/en-us/resources-services/resources/case-studies/)
- [eBooks & White Papers](https://www.minitab.com/en-us/resources-services/resources/ebooks-and-white-papers/)
- [Blog](https://blog.minitab.com/blog/?hsLang=en)
- [Data Sets](https://www.minitab.com/en-us/resources-services/resources/data-set/)
- [Webinars & Events](https://www.minitab.com/en-us/resources-services/resources/events/)
- [Education Hub](https://www.minitab.com/en-us/resources-services/resources/education-hub/)
- [Services](https://www.minitab.com/en-us/resources-services/services/)
- [Training](https://www.minitab.com/en-us/resources-services/services/training/)
- [Deployment](https://www.minitab.com/en-us/resources-services/services/deployment/)
- [Consulting](https://www.minitab.com/en-us/resources-services/services/statistical-consulting/)
- [Self-Paced Learning](https://www.minitab.com/en-us/resources-services/services/self-paced-learning/)
- [Continuing Education](https://www.minitab.com/en-us/resources-services/services/continuing-education/)
- Support
Back
[Support](https://www.minitab.com/en-us/support/)
[Technical Support](https://www.minitab.com/en-us/support/)
- [Subscriptions & Activation](https://www.minitab.com/en-us/support/subscriptions-and-activation/)
- [Minitab Quick Start](https://www.minitab.com/en-us/support/quick-start/)
- [Training](https://www.minitab.com/en-us/resources-services/services/training/)
- [Installation Support](https://www.minitab.com/en-us/support/installation/)
- [Support Videos](https://www.minitab.com/en-us/support/videos/)
- [Support Documentation](https://www.minitab.com/en-us/support/documents/)
- [Software Updates](https://www.minitab.com/en-us/support/software-updates/)
- [Product Downloads](https://www.minitab.com/en-us/support/downloads/)
- [Support Policy](https://www.minitab.com/en-us/support/policy/)
- Company
Back
[Company](https://www.minitab.com/en-us/company/)
[Company](https://www.minitab.com/en-us/company/)
- [About Us](https://www.minitab.com/en-us/company/our-company/)
- [Leadership Team](https://www.minitab.com/en-us/company/leadership-team/)
- [Partners](https://www.minitab.com/en-us/company/partners/)
- [Careers](https://www.minitab.com/en-us/company/careers/)
- [Contact](https://www.minitab.com/en-us/company/contact-us/)
- [News](https://www.minitab.com/en-us/company/press-releases/)
[Try/Buy](https://www.minitab.com/en-us/try-buy/)
- [Statistics](https://blog.minitab.com/en/blog/tag/statistics)
- [Data Analysis](https://blog.minitab.com/en/blog/tag/data-analysis)
-
- [Quality Improvement](https://blog.minitab.com/en/blog/tag/quality-improvement)
- [Subscribe](https://info.minitab.com/blog/subscribe?hsLang=en)
## Notice
You are now leaving minitab.com.
Click Continue to proceed to:
Continue
Go Back
# Tips and Tricks for Date/Time Data
Minitab Blog Editor | 10/26/2020
Topics: [Minitab Statistical Software](https://blog.minitab.com/en/blog/tag/minitab-statistical-software)
- [Share](https://www.linkedin.com/shareArticle?mini=true&url=https://blog.minitab.com/en/blog/quality-data-analysis-and-statistics/tips-and-tricks-for-date-and-time-data)
- [Share](https://www.facebook.com/sharer.php?u=https://blog.minitab.com/en/blog/quality-data-analysis-and-statistics/tips-and-tricks-for-date-and-time-data)
Whether you're an analyst, a Lean Six Sigma Master Black Belt, a researcher, a statistics student or all of the above, at some point you will need to work with data that involve either dates, times, or both. Do you know where all of your date/time tools are? Let’s take a quick trip through Minitab Statistical Software and see what it has to offer for date/time data:
Minitab’s easy-to-use interface makes it simple to manage and manipulate date/time data without having to type a single line of code. Changing date or time formats, extracting elements from a date/time column, or calculating elapsed times are a breeze in Minitab Statistical Software. To illustrate, I’ll use a random sample of 100 calls made to a call center between September 7 and September 18. The data are arranged in the worksheet from oldest to newest.
First, we may want to calculate [elapsed times](https://support.minitab.com/minitab/19/help-and-how-to/manipulate-data-in-worksheets-columns-and-rows/supporting-topics/date-time-data-and-formats/defining-custom-date-time-display-formats/?utm_campaign=Webinar%20Wednesdays&utm_source=blog&utm_medium=tips-tricks-date-time#elapsed-time-formats) to determine how long it took for the operator to answer each call, and the duration of each call. Minitab’s [Calculator](https://support.minitab.com/minitab/19/help-and-how-to/calculations-data-generation-and-matrices/calculator/create-a-formula-with-the-calculator/?SID=9550&utm_campaign=Webinar%20Wednesdays&utm_source=blog&utm_medium=tips-tricks-date-time) menu offers a powerful and comprehensive catalog of functions for managing numeric, text or date/time data. The **Elapsed Time** function is perfect for our call center scenario. Use **Calc > Calculator**, or right-click in the worksheet and choose **Formulas > Assign Formula to Column**:
Selecting the **Assign as a formula** check box or accessing the calculator by right-clicking in the worksheet will ensure that the calculated elapsed times will update automatically as more call times are added to the worksheet.
Elapsed times are excellent for visualizing call time variation on a time-series plot. Minitab’s brushing feature can then be used to investigate long call times and help focus improvement efforts.
**Pro tip**: To reduce the clutter on the graph, I right-clicked on the **Call Received** column and selected **Format Column** to delete hh:mm:ss (the associated times from the worksheet display). Don’t worry, this doesn’t *remove* the times, it only *hides* them from the worksheet display so they’ll look nicer on the graph. The times are still stored in the worksheet and can be-redisplayed in the Format Column window. To remove the associated times entirely so the date column can be used as a grouping variable, use **Data > Date/Time > Round Date/Time** instead.
To visualize the distribution of total call duration in minutes, we first use **Data > Date/Time > Extract to Numeric** to extract only the minutes from the elapsed time. Then we can use Minitab’s Graphical summary to visualize the results:
### Don't have Minitab yet?
[](https://cta-redirect.hubspot.com/cta/redirect/3447555/e4bc126d-f9a9-41b3-b201-6e5ea94edc2e)
### ... and soon you'll manipulate and visualize your date/time data like a pro!
### Plus: Sign up for the webinar and see the latest version in action:
[](https://cta-redirect.hubspot.com/cta/redirect/3447555/2ca0b688-8d4f-431e-baec-ab78c2e75bf5)
## You Might Also Like
[Confidence in Every Calculation: How Minitab Supports FDA-Regulated Validation](https://blog.minitab.com/en/blog/confidence-in-every-calculation-how-minitab-supports-fda-regulated-validation?hsLang=en)
[Minitab Solution Center](https://blog.minitab.com/en/blog/tag/minitab-solution-center) | 4 Minute Read
[Seedling Series #3: Simplifying Your Data Story with Minitab](https://blog.minitab.com/en/blog/seedling-series-3-simplifying-your-data-story-with-minitab?hsLang=en)
[Minitab Statistical Software](https://blog.minitab.com/en/blog/tag/minitab-statistical-software) | 3 Minute Read
[4 Solutions Minitab Can Help with in Agriculture](https://blog.minitab.com/en/blog/4-solutions-minitab-can-help-with-in-agriculture?hsLang=en)
[Minitab Connect](https://blog.minitab.com/en/blog/tag/minitab-connect) | 3 Minute Read
---
- [Careers](https://www.minitab.com/en-us/company/careers/)
- [Trust Center](https://www.minitab.com/en-us/trust-center/)
- [Suppliers](https://www.minitab.com/en-us/suppliers/)
- [Site Map](https://www.minitab.com/en-us/site-map/)
- [](https://www.linkedin.com/company/minitab/)
- [](https://www.facebook.com/Minitab/)
- [](https://www.youtube.com/user/MinitabInc)
- [](https://www.instagram.com/minitab/)
---
© 2025 Minitab, LLC. All Rights Reserved.
- [Terms of Use](https://www.minitab.com/en-us/legal/terms-of-use/)
- [Privacy Policy](https://www.minitab.com/en-us/legal/privacy-policy/)
- [Legal](https://www.minitab.com/en-us/legal/)
- Cookies Settings