TIMEVALUE Function in Excel: Text Time to Real Time
DateLevel: IntermediateAvailable in: Excel 2007+TIMEVALUE turns text like "2:45 PM" into a real time you can add and.
Read article →Date & Time
Excel Date & Time functions explained with syntax, examples and common mistakes.
📊
← Excel
Date & Time
Excel Date & Time functions explained with syntax, examples and common mistakes.
📄 25 articles⬇️ 25 with practice files🕒 Updated 5 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →DATEVALUE Function in Excel: Convert Text Dates Into Real Dates
DATEVALUE Function in Excel: Convert Text Dates Into Real Dates
DATEVALUE turns a date written as text into a real date number. It follows your Windows regional settings, which is exactly why it sometimes…
Read article →MINUTE Function in Excel: Minute From a Time
MINUTE Function in Excel: Minute From a Time
DateLevel: BeginnerAvailable in: Excel 2007+MINUTE returns 0–59 from a time.Syntax=MINUTE(serial_number)ArgumentWhat it.
Read article →SECOND Function in Excel: Second From a Time
SECOND Function in Excel: Second From a Time
DateLevel: BeginnerAvailable in: Excel 2007+SECOND returns 0–59. Mostly used to strip seconds from machine.
Read article →HOUR Function in Excel: Hour From a Time
HOUR Function in Excel: Hour From a Time
HOUR returns 0–23 from a time or date-time. The quickest way to group call-centre or sales data by hour of day.
Read article →TIME Function in Excel: Build a Time From Hours, Minutes, Seconds
TIME Function in Excel: Build a Time From Hours, Minutes, Seconds
TIME creates a time value. Excel stores time as a fraction of a day: 12:00 is 0.5, 6:00 is 0.25.
Read article →NOW Function in Excel: Current Date and Time
NOW Function in Excel: Current Date and Time
NOW returns the current date and time and updates every time the sheet recalculates. For a timestamp that stays fixed, press Ctrl+; then Space…
Read article →WORKDAY.INTL Function in Excel: Due Date With Your Own Weekend
WORKDAY.INTL Function in Excel: Due Date With Your Own Weekend
WORKDAY.INTL adds working days with a custom weekend — delivery or SLA dates for a six-day operation.
Read article →NETWORKDAYS.INTL Function in Excel: Working Days With Your Own Weekend
NETWORKDAYS.INTL Function in Excel: Working Days With Your Own Weekend
NETWORKDAYS.INTL counts working days when your weekend is not Saturday–Sunday — a Sunday-only week, or a Friday–Saturday weekend in the Gulf.
Read article →DAYS360 Function in Excel: Days on a 360-Day Year
DAYS360 Function in Excel: Days on a 360-Day Year
DAYS360 counts days as if every month had 30 — the convention some interest and bond calculations use.
Read article →DAY Function in Excel: Day of the Month
DAY Function in Excel: Day of the Month
DAY returns 1–31 from a date. Pair it with YEAR and MONTH to rebuild or test dates.
Read article →ISOWEEKNUM Function in Excel: ISO Week Number
ISOWEEKNUM Function in Excel: ISO Week Number
ISOWEEKNUM returns the ISO 8601 week (weeks start on Monday; week 1 holds the first Thursday). Use it when European teams or SAP reports…
Read article →