View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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 :)