• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / TIMEVALUE

TIMEVALUE

posted on August 30, 2019

« Back to Glossary Index

Syntax

TIMEVALUE(time_text)

Tutorial with example

TIMEVALUE function converts a time in text format to a time in datetime format.

In this video, I am going to show your how to calculate how late are your employees and how much would you discount of the payroll if you had a 2$ fee for each 15 min late using among others TIMEVALUE function.

Keynotes:
03:00 Calculate how many minutes or hours and employee is late with DATEDIFF function
05:00 Calculate how many 15 minutes interval he is late : QUOTIENT function
10:00 Extract minutes from a time column in DAX: TIMEVALUE and MINUTE funcitons
12:00 Extract decimals from a number with MOD function
13:20 Convert a number to a logical function : true or false with INT function
14:00 Calculate payroll fee if employee is late

DAX Fridays! #139: Calculate hours late and penalty fees with QUOTIENT, MODE and TIMEVALUE

Download example files:

Download the pbix and excel file here.

Remarks

Time values are a portion of a date value and represented by a decimal number. For example, 12:00 PM is represented as 0.5 because it is half of a day.

When the time_text argument is a text representation of the date and time, the function uses the locale and date/time settings of the client computer to understand the text value in order to perform the conversion. Most locales use the colon (:) as the time separator, and any input text using colons as time separators will parse correctly. Review your locale settings to understand your results.

Was this helpful?
See Also:
  • MINUTE
« Back to Index

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In