How do you add 20 minutes to a time value in Microsoft Excel?

What is the difference between a time value and a date & time value?

 

There is a lot of confusion about data and time values in Microsoft Excel but it’s easy to learn!

A date value is an integer (i.e. a number without decimal values like 42241). 

time value is a decimal (i.e. 0.5 = noon. Closer to midnight looks like this 0.94).

 

We format these values to make them look like readable date and time values: 

  • 25/08/2015   =   42241                           Date without a time value
  • 12:00:00 PM =  0.5                                   Time without a date is a fraction of 1 day
  • 25/08/2015  12:00:00 PM =  42241.5    Date & Time (noon on August 25th, 2015)

 

Watch my YouTube video   

 

Learn More!

Excel Date & Time

Mastering Excel Date & Time Formulas

by Tim Hill is a quick read and great e-book.

The book also has a helpful companion Excel file.

 

 

Subscribe to my YouTube channel and learn more!

See my free templates here!

Post a comment