Multiply minutes by number and add to time

[sabine]

I need to calculate start times for an event, the event starts and each entry will take 2.5 minutes, I need to calculate when the next entry starts

Here is what this should look like

A | B |C |D | E

2 |8:30 AM |a |5 |= C2 * 2.5 min |= A2 + total min D2
3 | = E2 |b |4 |= C3 * 2.5 min |= A3 + total min D3
4 | = E3 |c |3


Can someone help me with this?

Thanks
Sabine

 

[Andrew Poulsom]

To convert 2.5 minutes to a serial time:

=2.5/1440

which returns 00:02:30 when formatted as hh:mm:ss.

 

[sabine]

thanks, that did it