Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting days into weeks
Hi I am trying to convert days into weeks and everythings fine until you have
only 5 days showing, but this shows up as 0.7. The formula I am using is D3/7 and i have also tried (D3-1)/7 and this shows 0.6. -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
Answer: converting days into weeks
Converting Days to Weeks in Excel
When you have a number of days that you want to convert to weeks with a decimal representing the fraction of a week, you can use the following formula in Excel: =D3/7.0
For example, if you have 5 days in cell D3, the formula will give you 0.71 weeks.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting days into weeks
Round it, either round, roundup or rounddown depending upon your
requirements. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "chedd via OfficeKB.com" <u18187@uwe wrote in message news:729b594c161e3@uwe... Hi I am trying to convert days into weeks and everythings fine until you have only 5 days showing, but this shows up as 0.7. The formula I am using is D3/7 and i have also tried (D3-1)/7 and this shows 0.6. -- Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting days into weeks
chedd wrote:
Hi I am trying to convert days into weeks and everythings fine until you have only 5 days showing, but this shows up as 0.7. The formula I am using is D3/7 and i have also tried (D3-1)/7 and this shows 0.6.Therfore could someone please what formula i need to show 0.5. -- Message posted via http://www.officekb.com |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting days into weeks
Hi I am trying to convert days into weeks and everythings fine until you
have only 5 days showing, but this shows up as 0.7. The formula I am using is D3/7 and i have also tried (D3-1)/7 and this shows 0.6. Therfore could someone please what formula i need to show 0.5. Are you saying you want the number after the decimal point to be the actual number of days and not the actual fraction of a week that the number of days represents? Rick |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting days into weeks
If you want to divide a number by 7 and get the answer 0.5, then the number
is 3.5. Bear in mind that when you divide 5 by 7 and see 0.7, that is because you are displaying only one decimal place. If you increase the number of places you will see more precision. Similarly when you divide 4 by 7 and see 0.6. -- David Biddulph "chedd via OfficeKB.com" <u18187@uwe wrote in message news:729b8e5bec410@uwe... chedd wrote: Hi I am trying to convert days into weeks and everythings fine until you have only 5 days showing, but this shows up as 0.7. The formula I am using is D3/7 and i have also tried (D3-1)/7 and this shows 0.6.Therfore could someone please what formula i need to show 0.5. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weeks and days sorting out | Excel Discussion (Misc queries) | |||
minutes seconds days weeks years | Excel Discussion (Misc queries) | |||
Converting Dates to Weeks | Excel Worksheet Functions | |||
How to calculate in weeks and days? | Excel Discussion (Misc queries) | |||
A number of days into weeks and days | Excel Worksheet Functions |