I need help on getting the right added time shown. Below is the output I needed.

 

Start time : 10.30am

Repair time : 4.15 hours

 

Output wanted : 2.45pm

Output I get : 2.00pm

 

 

I only manage to get the hour shown correct. How can I make the minute shown correct too?Below are my formula.

 

DateAdd ("h", {ASSIGNS.ESTREPAIRHRS}+hour({ASSIGNS.STARTTIME}),{ASSIGNS.SCHEDDATE})

 

 

 

Please kindly advice on how I should type the formula in order to get the correct time shown?

 

 

 

Thanks in advance~

 

 

 

Elisha

Sorry my mistake.The output that I wish to get is 2.45pm. If I change the formula below to minutes, it shows the wrong time. 

  

DateAdd ("n", {ASSIGNS.ESTREPAIRHRS}+minute({ASSIGNS.STARTTIME}),{ASSIGNS.SCHEDDATE})

 

 

Is there any other way I can write the formula to add up the time?

 

Urgently need help on this.

 

 

 

Thanks in advance~

 

 

Elisha

 

I try the formula already. But it gives me the wrong time also. {ASSIGNS.ESTREPAIRHRS} is number of hours enter by user.

 

so, this should work:

DateAdd ("m", {ASSIGNS.ESTREPAIRHRS}*60,{ASSIGNS.STARTTIME})

 

this adds the estimated time to the start time....which should give the completed time.  I don't know if adding the schedule date gets you a better number...if it is just a date, without time, then it shouldn't matter, but given the output desired, I wouldn't bother with date part.