Time calculation by adding minutes

**lavan_joy** · 03-12-2013, 07:58 AM

Hi Excel experts

I need some formulas for the following:
Example:
Start time: 10:30 + 75 minutes = End Time1+ 90 minutes =End Time 2+60 minutes =End Time 3

Start time- Manual Entry
Minutes- Manual Entry
End Time1,End Time 2, End Time3… should be calculated

I have attached the sample excel sheet.

Thanks.Time.xlsx

**martindwilson** · 03-12-2013, 08:11 AM

c2= =(A2*1440+B2)/1440
e2= =(C2*1440+D2)/1440
g2= =(E2*1440+F2)/1440

**Fotis1991** · 03-12-2013, 08:14 AM

Try

=A2+TIME(0,B$2,0)

**lavan_joy** · 03-12-2013, 08:27 AM

Thanks a lot to both of you.
Reps added to both of you for your quick solution.
Solved
martindwilson's solution is very useful one for multiple entries in a sheet.