Hello friends today we will discuss about two new basic Formula (Time and Today)
Shown:-when the cell change into time format it look like (hh:mm:ss).
(H) means hour:- Hour means the measurement of time. In which their are 60 minutes.
(M) means Minute:- its also measurement of time. In which their are 60 seconds.
(S) means Second:- its also measurement of time.
Formula =Date(HH:MM:SS)
Today
Today;- Its convert general cell into time format.
In this image you see how its work.
At this image you enter this formula in a general cell,its change automatically change into date format.
No comments:
Post a Comment