Time Adding

[samdev]

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

 

[RagDyeR]

Start time in A1 (true XL recognized time, entered like 7<space>A, 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!
=====================================================

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

 

[Gary Brown]

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]

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







- Show quoted text -

Works great - thx!