Formula for time.

[Nicole]

Hi,

I would like to be able to work this into a formula:

Units (20) x Cycle time (1.82) = Minutes (36.4) and then + Start Time ie.
7:00am = the Finish time??

Does anyone have a formula that I could use?

Thank you

 

[Jacob Skaria]

Hi Nicole

Try the below

Col A Col B Col C Col D
StartTime Units CycTime EndTime
7:30 AM 20 1.82 =formula

=A2+(B2*TIME(0,INT(C2),MOD(C2,1)*60))

PS: I assume cell A2 is having the start time in excel date/time format. To
enter the time use short cut is (Ctrl + Shift + semicolon) and then edit to
suit...

If this post helps click Yes

 

[Jacob Skaria]

Thanks David; For the example I took cycle time as 1.82 (1 minutes and 0.82
seconds) . I didnt notice the 36.4..Am I missing something here??

Col A Col B Col C Col D
StartTime Units CycTime EndTime
7:30 AM 20 36.4 =formula

=A2+(B2*TIME(0,INT(C2),MOD(C2,1)*60))



If this post helps click Yes

 

[Jacob Skaria]

Thanks David for your time in elaborating. I understand; I went wrong.....