Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
relative time
Ok, say I have a number representing time. For instance, 3.41 months. I would
like to calculate (with some accuracy) to how many days this is. I have a reference date, and I use =DAY(DATE(YEAR(B4),MONTH(B4)+1,0)) to count the days in my reference date. I'm looking to "pick apart" the 3.41 to change my formula to the next month, count the days, etc. I could then multiply .41 to the days in the 4th month and then add them all together to get my end result. Trick is, to do any of the above. Any Takers? -- I reject your reality and substitute my own. Promote hydrogen - one of the best "clean" fuels there are! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
How to chnge 35 relative cells to 35 absolute cells at one time. | Excel Worksheet Functions | |||
Timetables - next departure how to find relative to system time | Excel Programming | |||
Relative time in SQL | Excel Programming |