Haven't you lost a few seconds there, Jacob? You've added 36:20 instead of
the 36:24 that Nicole wanted.

Try =A2+(B2*C2/(24*60))
--
David Biddulph

"Jacob Skaria" wrote in message
...
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


"Nicole" wrote:

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 :)