Calculating Cell value hours from Now()

[Middletown]

Hi all,

Long time luker now hoping for some help. please.

We wish to maintain a running log of prodcution scheduling.

The format we have been attempting is


(E1)Print Date & Time (F1)9/21/2016 (G1)4:55:36 PM

Job Number Part Number Description Actual Hours Required Date Time End Date End Time

32540 S00099 .45lbs/ft2" 6.50 9/21/2016 4:55:36 PM ? ?

Print date and Time are to be calc using now() when opened. (E1) above etc are cell refs.
the date and time are entered as "=F1" & "=G1" respectively
we wish to populate "End date" and "End Time" by entering the value of "actual hours required" as a number then populate recurring lines below for each "job number"

I thought it would be fairly easy, but was sadly mistaken, at least to me, ive searched and read this and other forums before yeilding to your experience.

Any suggestions would be greatly appreciated

Thank you

 

[sheetspread]

hours/24

 

[V_Malkoti]

Like sheetspread said, if you add (Actual Hours/24) to Date Time, you should get the right values.

[TABLE="class: grid, width: 672"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD]Job Number[/TD]
[TD]Part Number[/TD]
[TD]Description[/TD]
[TD]Actual Hours Required[/TD]
[TD]Date Time[/TD]
[TD]End Date[/TD]
[TD]End Time[/TD]
[/TR]
[TR]
[TD="align: right"]32540[/TD]
[TD]S00099[/TD]
[TD].45lbs/ft2"[/TD]
[TD="align: right"]6.5[/TD]
[TD="align: right"]9/21/2016 4:55:36 PM[/TD]
[TD="align: right"]9/21/2016[/TD]
[TD="align: right"]11:25:36 PM[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]=E2+D2/24[/TD]
[TD]=E2+D2/24[/TD]
[/TR]
</tbody>[/TABLE]

Set format of End Date column to Short Date and End Time column to Time.

 

[Middletown]

Sheetspread and V_Malkoti

Thank you very kindly.

 

[V_Malkoti]

Glad we could help.