I want to convert hours into # of years, months and days. I have built a formula that does it but it is not accurate as it's based on each month being 30 days....any help with this would be appreciated
I want to convert hours into # of years, months and days. I have built a formula that does it but it is not accurate as it's based on each month being 30 days....any help with this would be appreciated
As you pointed out the conversion need a starting date to make sense. For
example 700 hours starting from the beginning of Jan.2006 is 0 years, 0
months, 29 days
700 hours starting from the beginning of Feb 2006 is 0 years, 1 months, 1 days
Put the starting date in A1
Put the total hours in B1
Put =A1+B1/24 in C1
In D1 put:
=DATEDIF(A1,C1,"y") & " years, " & DATEDIF(A1,C1,"ym") & " months, " &
DATEDIF(A1,C1,"md") & " days"
--
Gary's Student
"dkuz" wrote:
>
> I want to convert hours into # of years, months and days. I have built a
> formula that does it but it is not accurate as it's based on each month
> being 30 days....any help with this would be appreciated
>
>
> --
> dkuz
> ------------------------------------------------------------------------
> dkuz's Profile: http://www.excelforum.com/member.php...o&userid=31536
> View this thread: http://www.excelforum.com/showthread...hreadid=512279
>
>
I was not clear in my question.....
What I want to do is subtract hours from todays date to get a new date:
For example if today is Feb 14, 2006 and someone has worked 12354 hrs, and they work 7 hours a day......I want to convert every 7 hrs into a "day" and subtract the "days" from the current date in order to give me a date that the person started work. Thanks!
With the date in A1 and the number of hours in B1:
=A1-((B1/7)/24)
Days are whole numbers and hours are 1/24th of a day.
Give the cell a date format.
dkuz wrote:
>
> I was not clear in my question.....
>
> What I want to do is subtract hours from todays date to get a new
> date:
>
> For example if today is Feb 14, 2006 and someone has worked 12354 hrs,
> and they work 7 hours a day......I want to convert every 7 hrs into a
> "day" and subtract the "days" from the current date in order to give me
> a date that the person started work. Thanks!
>
> --
> dkuz
> ------------------------------------------------------------------------
> dkuz's Profile: http://www.excelforum.com/member.php...o&userid=31536
> View this thread: http://www.excelforum.com/showthread...hreadid=512279
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks