Skip to content

All-Access: every lesson, no ads. $8.25€8.25US$8.25$4.08US$4.08$2.41US$2.41₹224.91MX$74.91 a month, billed yearly. Free to start. Cancel any time

See plans
All-Access, no ads: every lesson, course and template. $8.25€8.25US$8.25$4.08US$4.08$2.41US$2.41₹224.91MX$74.91 a month. + GST at checkoutSee the plans →

Date Functionslesson 92 of 95

TIME Functions

0daysLet's get rolling!

Loading the data...

0streak
0 XP today
All Lessons

TIME Functions - Excel Practice Online

This interactive exercise teaches you TIME Functions in Excel through 6 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Date Functions track and works right in your browser - no Excel install and no download. Start free.

Practising TIME Functions this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete Excel practice course.

What you'll practice in this TIME Functions lesson

  1. Excel stores time as a fraction of a day. =NOW() returns the current date and time. Type =NOW() in B2. - NOW has no arguments. It recalculates whenever the sheet does. TODAY() is date only; NOW() is date plus time.
  2. Build 9:15 AM from hour, minute, second. Type =TIME(9,15,0). - TIME(hour, minute, second) returns a time serial. 9:15 is 9.25 hours / 24. Format the cell as Time to see 9:15 AM instead of 0.385.
  3. Same time, from the cells. Hour is in A2, minute in B2: =TIME(A2,B2,0). - Pull hour and minute from the grid instead of typing them. Second argument 0 means on the minute.
  4. B2 already holds a TIME. Pull the hour with =HOUR(B2). - HOUR returns 0–23. 14:30 is 2:30 PM, so HOUR is 14. MINUTE and SECOND work the same way.
  5. Same stamp. Pull the minutes: =MINUTE(B2). - 14:30 has minute 30. HOUR, MINUTE, SECOND split a time serial back into parts you can test or add.
  6. Hour of right now: =HOUR(NOW()). - Nest NOW inside HOUR (or MINUTE) when you need the current clock part. This updates every recalc, same as NOW.

TIME Functions practice - FAQ

How do I practice TIME Functions in Excel?

Open this LogicExcel exercise and work through 6 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation. You need no Excel install.

Is the TIME Functions exercise free?

Your first two lessons are free with a free account. After that the pass opens all 95 lessons, the Academy and the accounting course. Lessons you finish stay open.

What will I learn in this TIME Functions lesson?

This lesson covers TIME Functions as part of the Date Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.