Trying to Fix minutes

[Wolfin2010]

Hi!

I'm banging my head with the timesheet but heading nowhere; if anyone can help me out that would be highly appreciated.

Here what I'm trying to do.

I have two time Actual Time and Adjusted Time I'm trying to create an automatic system using if or any other formula where I could get the adjusted time without manually entering it.

 

[Tetra201]

If you are willing to use the following minute coversions

53...07 --> 00
08...22 --> 15
23...37 --> 30
38...52 --> 45

then you can get the Adjusted Time from the Finish Time with this formula:

=MROUND(D2,"0:15")

From the posted example, it's not clear how the Start Time is converted into the Adjusted Time.

 

[Wolfin2010]

Thank you that helped a lot, I was looking for something like that.
There is a timing issue for the start time but that what it supposed to do.
Is there a way to have

08...23 --> 15
24...38 --> 30
39...52 --> 45

instead of

08...22 --> 15
23...37 --> 30
38...52 --> 45

 

[Tetra201]

... Is there a way to have

08...23 --> 15
24...38 --> 30
39...52 --> 45

Try this:

=MROUND(D2-AND(MINUTE(D2)>22,MINUTE(D2)<39)/1440,"0:15")

 

[Wolfin2010]

Thank you sir you have no Idea how much I appreciate that.

 

[Tetra201]

Glad to have helped.