Formula for time.
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 :)
|