| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Adding
Scenario:
Calculate the number of hours to do a task - each task will take different amount of time. Want to calculate the finish time of the task based on the start time. Example: Task 1: Takes 7.8 hours and starts at 7 a.m. - what is the finish time? Task 2: Takes 8.5 hours and starts at 2 p.m. what is the finish time? Thx!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Adding
Start time in A1 (true XL recognized time, entered like 7<spaceA, then
<Enter) Hours in B1 (decimal number) in C1: =B1/24+A1 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "samdev" wrote in message ... Scenario: Calculate the number of hours to do a task - each task will take different amount of time. Want to calculate the finish time of the task based on the start time. Example: Task 1: Takes 7.8 hours and starts at 7 a.m. - what is the finish time? Task 2: Takes 8.5 hours and starts at 2 p.m. what is the finish time? Thx!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Adding
7 am + (7.8/24) = 2:48 pm
2 pm + (8.5/24) = 10:30 pm -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "samdev" wrote: Scenario: Calculate the number of hours to do a task - each task will take different amount of time. Want to calculate the finish time of the task based on the start time. Example: Task 1: Takes 7.8 hours and starts at 7 a.m. - what is the finish time? Task 2: Takes 8.5 hours and starts at 2 p.m. what is the finish time? Thx!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Adding
On Jul 1, 10:48*am, Gary Brown
wrote: 7 am + (7.8/24) = 2:48 pm 2 pm + (8.5/24) = 10:30 pm -- Hope this helps. * If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "samdev" wrote: Scenario: Calculate the number of hours to do a task - each task will take different amount of time. Want to calculate the finish time of the task based on the start time. Example: Task 1: Takes 7.8 hours and starts at 7 a.m. - what is the finish time? Task 2: Takes 8.5 hours and starts at 2 p.m. what is the finish time? Thx!!- Hide quoted text - - Show quoted text - Works great - thx! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time | Excel Worksheet Functions | |||
| Adding time AM/PM | Excel Discussion (Misc queries) | |||
| Time log adding time from separate sheets | New Users to Excel | |||
| Adding time | New Users to Excel | |||
| Adding time to date-time formatted cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
