Category: Date and Time

This function adds a specific number of days (for example, 11) to a timeline with the dd/mm/yy or dd/mm/yyyy formats. For instance, assume you want to add 11 days to the 05/06/24 (5 June, 2024) date. After you use the ADDDAYS() function to add 11 days to the 05/06/24 date, it performs the addition and… Continue reading Add Days

This function adds a value in seconds to a specific time. For instance, assume you add 25 seconds to the 2:10:12 time by using the ADDSECONDS() function. When the ADDSECONDS() function is executed, it will return 2:10:37 as the value of time after it adds 25 seconds to the 2 hours, 10 minutes, and 12 seconds. You can use the ADDSECONDS() function as follows: To use the ADDSECONDS… Continue reading Add Seconds

This function adds a value in minutes to a specific time. For instance, assume you add 30 minutes to the 2:10:34 time by using the ADDMINUTES() function. When the ADDMINUTES() function is executed, it will return 2:40:34 as the value of time after it adds 30 minutes to the 2 hours, 10 minutes, and 34 seconds. You can use the ADDMINUTES() function as follows: To use the ADDMINUTES function:… Continue reading Add Minutes

This function adds a value in hours to a specific time. For instance, assume you add 10 hours to the 2:10:34 time by using the ADDHOURS() function. When the ADDHOURS() function is executed, it will return 12:10:34 as the value of time after it adds 10 hours to the 2 hours, 10 minutes, and 34… Continue reading Add Hours