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!!

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!!

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!!

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!