DATE AND TIME IN EXCEL

                                                               MICROSOFT EXCEL

Calculating the number of days from a date

=Today()  this command shows the current date

=TODAY()-B25 

 to calculate a result which includes the current date an extra 1 will need to be added.

=TODAY()-B25+1

 =TIME(Hour,Minute,Second)

This function will convert three separate numbers to an actual time.

Hour	Minute	Second	Time
15	30	59	3:30 PM	=TIME(C4,D4,E4)
13	30	59	1:30 PM	=TIME(C5,D5,E5)
14	30	59	2:30 PM	=TIME(C6,D6,E6)

The result will be shown as a time which can be formatted either as 12 or 24 hour style.

Time Calculation
in time	out time	(B-A)
A	B	B-A
09:30	18:30	09:00
09:35	17:35	08:00
10:40 AM	6:40 PM	08:00

we cab add the time until its not exceed 24 hours

IF WE WANT TO ADD TIME MORE THAN 24 HOURS

 we have to change format of time by CTRL + 1 (format cell> custom>[hh]:mm  

=DATE(year,month,day) Day Month Year Date 25 12 20  =DATE(D54,C54,B54) 25 12 99  =DATE(D55,C55,B55) 16 12 99  =DATE(D56,C56,B56)

 

=DAYS360(StartDate,EndDate,TRUE of FALSE)

01-Jan-20	02-Feb-20	31	=DAYS360(C4,D4,TRUE)
01-Jan-20	02-Feb-20	31	=DAYS360(C5,D5,TRUE)

Calculating the age in excel

We can calculate a persons age based on their birthday and today's date.

The calculation uses the DATEDIF() function. Birth date : 6 July 2004

Years lived :	16.00	=DATEDIF(C8,TODAY(),"y")
and the months :	1.00	=DATEDIF(C8,TODAY(),"ym")
and the days :	13.00	=DATEDIF(C8,TODAY(),"md")

We can put this all together in one calculation, which creates a text version.

You Age is

16 Years,1 Month,13

=DATEDIF(I5,TODAY(),"y")&" Years," & DATEDIF(I5,TODAY(),"ym")&" Month,"&DATEDIF(I5,TODAY(),"md")&"days"

(Note Use cell Number As per your working Sheet)