| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add a portion of a day to a date?
I am trying to create a schedule in excel using the workday formula. I have
percentages of a day that I want to add. For example, one job takes 1.75 of a day to complete and I will be starting on 4/16, then I will finish 4/17. I then want to take the finish date and the balance of the day and and the next job. Please help if you can or let me know if this makes any sense. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add a portion of a day to a date?
In A1 enter:
4/21/2008 In B1 enter: 1.75 In C1 enter: =A1+B1 format C1 as Custom m/d/yyyy h:mm:ss and you will see: 4/22/2008 18:00:00 -- Gary''s Student - gsnu200781 "notanexcelguru" wrote: I am trying to create a schedule in excel using the workday formula. I have percentages of a day that I want to add. For example, one job takes 1.75 of a day to complete and I will be starting on 4/16, then I will finish 4/17. I then want to take the finish date and the balance of the day and and the next job. Please help if you can or let me know if this makes any sense. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add a portion of a day to a date?
One more issue. I need to only include weekdays. I tried the workday
function but then my hour and min goes back to 00:00 "Gary''s Student" wrote: In A1 enter: 4/21/2008 In B1 enter: 1.75 In C1 enter: =A1+B1 format C1 as Custom m/d/yyyy h:mm:ss and you will see: 4/22/2008 18:00:00 -- Gary''s Student - gsnu200781 "notanexcelguru" wrote: I am trying to create a schedule in excel using the workday formula. I have percentages of a day that I want to add. For example, one job takes 1.75 of a day to complete and I will be starting on 4/16, then I will finish 4/17. I then want to take the finish date and the balance of the day and and the next job. Please help if you can or let me know if this makes any sense. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| send only a portion of a workbook | Excel Discussion (Misc queries) | |||
| Matching the month and year portion of a date only | Excel Discussion (Misc queries) | |||
| how do i copy only a portion of a spreadsheet | Excel Discussion (Misc queries) | |||
| copy only a portion of a spreadsheet | Excel Discussion (Misc queries) | |||
| Sorting a portion of a range | Excel Worksheet Functions | |||
Linear Mode
