Excel Function of the Month – TIME

The Excel Function of the month is

TIME

Description

Converts hours, minutes and seconds as given numbers into Excel time format.

Usage

The TIME function will take three numbers and convert them into the H, M, S time format. This can be useful when doing calculations that involve time.

Check out my Excel posters for your classroom

Excel-Functions-PostersI have created posters that you can stick up in your class. There are 33 posters. Below is an index of what functions are available and a sample sheet (to the right) showing what the posters look like. You can purchase them from the Tech Teachers online shop.

Functions covered

AND, AVERAGE, CONCATENATE, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, FIND, INT, LARGE, LEFT, LEN, LOWER, MAX, MEDIAN, MID, MIN, MODE, NOW, OR, POWER, RAND, RANDBETWEEN, RIGHT, ROUND, SMALL, SUM, SUMIF, TIME, TODAY, UPPER, VLOOKUP

Find out more about the posters here

About Matthew Hains 782 Articles
Matthew is a Computer Applications Technology teacher at an independent school in South Africa.

Be the first to comment

Leave a Reply

Your email address will not be published.


*