The TIME function in Excel is a built-in function that allows you to build a time with separate components for each hour, minute, and second. When you need to construct a proper time within another formula, the TIME function comes in handy. Make a clock with the hours, minutes, and seconds.
In Cell A1, type a date, and in Cell B1, type =EDATE(4/15/2013,-5). We're entering a date surrounded in quote marks to specify the value of the start date. For the same effect, you can simply refer to a cell that holds a date value or use the formula =EDATE(A1,-5)
Learner's Ratings
3.7
Overall Rating
50%
20%
5%
7%
18%
Reviews
R
RAHUL KATHAD
5
****
J
Joy Dutta
4
sir course is awesome but the assignment not given
H
Harshada Munfan
5
Nice course
P
Pratik Meshram
5
where is assignment PDF
Gourav Parmar
5
Hey Provide me the Practice File
G
Gitesh Saini
5
This aap very helpful for human
R
Rishu Baghel
4
sir, can you provide us some table for practice?
S
shams faishal
4
please provide your excel file so it will be easy to learn fast
P
Pintu Kumar
5
improve video quality, because its excel file and the pixel is not good.
Share a personalized message with your friends.