Excel Date and Time Query

[Sai]

Hi,

Can you please help me how to create a formula in excel in order to obtain the number of days and time since last 100 year from the current date.

Much appreciate on your help.

Regard
Sai

 

[Marc L]

Hi !

As it depends on the expected result sample worbook
you forgot to attach ! (See the forum rules …)
​

 

[bosco_yip]

Perhaps,

=DATEDIF(DATE(YEAR(TODAY())-100,MONTH(TODAY()),DAY(TODAY())),TODAY(),"d")+1

Regards
Bosco

 

[Sai]

Hi Bosco,

Thanks for the formula but it's not working hence i have attached the excel file where i got the number of days between two dates.

Now my query is here how to fetch the time, means how much times have been spent in those days.

Regards
Sai

 

[Belleke]

Not sure what you want.
If your date in F8 is a real date and not a formula you can try this.

=INT(F7-F8) & " days, " & HOUR(F7-F8) & " hours, " & MINUTE(F7-F8) & " minutes and " & SECOND(F7-F8) & " seconds"

 

[pecoflyer]

Now my query is here how to fetch the time, means how much times have been spent in those days.

Regards
Sai

What do you mean? How many hours min and sec ?

 

[Sai]

Yes i need how many hrs min and second completed in these 100 years

 

[pecoflyer]

Use DATEDIF to calculate the number of days between the dates (post #3) than multiply by the number of seconds in a day