Thursday, 1 October 2015

(Time and Today)


Hello friends today we will discuss about two new basic Formula (Time and Today)



    Time :-  when you enter a time formula in a general cell its                            convert the cell into time format.

    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.







Share This Post →


No comments: