LinkBack URL
About LinkBacks
How do I calculate age in hours in excel 2007 without actually writing today's date in column. I am trying to calculate equipment purchased on 12/22/1999, how old is it today by hours.
Thank you
How do I calculate age in hours in excel 2007 without actually writing today's date in column. I am trying to calculate equipment purchased on 12/22/1999, how old is it today by hours.
Thank you
if the equipment date is in A1
Formula:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
or...
=24*(TODAY()-A1)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Number of hours, assuming your date is in A1:
Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
=(TODAY()-cell with the date in)*24
will be to the day
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I am using Excel 2007 and it does not have =dateif formula.
this formula works, thank you Glenn Kennedy
Thank you all for you help! I got few working formulas.
That's DATEDIF and it's available in Excel 2007.Originally Posted by gill123
It won't be listed in the Insert Function userform.
You have to manually type it in.
See this:
http://www.cpearson.com/Excel/datedif.aspx
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks