Adding to time (without including date)

[MckBen91]

So I'm trying to create a formula where if its true, it will add 15 or 30 minutes to a time (if the projected time is greater than the the break time add 15 or 30 mins). But as the "projected" time requires a date along side it, (07/11/2021 15:35) it wont add to the cell unless I put a date in front of the break time. Adding a date in front if the break time wont work for what I'm trying to achieve. Is there another way of solving this?

 

[GWteB]

You could use TIMEVALUE for that:

Book1
	A
1	7-11-2021 16:50:57
2	00:15:00
3	7-11-2021 17:05:57
Sheet1

Cell Formulas
Range	Formula
A1	A1	=NOW()
A2	A2	=TIMEVALUE("00:15:00")
A3	A3	=A1+A2

 

[NoSparks]

Your break times have to be in the same work day as the start time.
If you just enter 6:00 it will be Jan 1, 1900 6:00am
so, based on your file from here
E3 needs to = B5 and the rest of the break times calculated from there.
=E3+2/24 would be the next break time.
The cells can be formatted to just show the time.

I'll admit I'm no good with formulas and I'm going fishing shortly so won't be looking at that other thread for a while.
Hopefully another member will take an interest.