Time

[MarcRN]

I am attempting to create a form/spreadsheet that will add time to an
original time. For example we have 1145 as a start time. I have task to
accomplish @ 15 minutes, 30 minutes, 1 hour, 1.5 hours. Can someone please
help me with this. Thank you.

 

[T. Valko]

Assume A1 is the true Excel time 11:45 AM

To add those time increments:

=A1+TIME(0,15,0)
=A1+TIME(0,30,0)
=A1+TIME(1,0,0)
=A1+TIME(1,30,0)

 

[Jacob Skaria]

A1 = start time
=A1+TIME(0,15,0)

If this post helps click Yes