Time and Date Forumla Issues

I am trying to create a maintenance excel sheet where I have a date and time in one cell then depending on the time of the task add it from the other cell. I can add it no problem if it was just 4 days. i.e 27/04/2013 13:43 + 2 days = 29/04/2013 13:43. However it is trying to add it when it comes to minutes and hours that I am having trouble with as the Cells that have the duration they have to resolve the maintenance is just a number. I have attempted various things but I cannot get anywhere.

Can anyone else at all please?

Thank you.

Trying to get the answer from Collum f + collum h = collum j

Maintenance Example Forum.xls

Put real day/time values in column F on the allocation & codes sheet.
F2 = 14
F3 = 4:00:00
F4 = 1:30:00
F5 = 7
F6 = 1
F7 = 5:00:00

Then on the Log sheet, J3 formula is
=F3+VLOOKUP(H3,'Allocation & Codes'!$E$2:$F$7,2,FALSE)

Try this:

=F3+(LEFT(H3,FIND(" ",H3)-1)/(24*60))

Assuming that H3 is always expressed in minutes

Works really well only thing I am wondering is can you put it into working hours MOnday to Friday 9:00am - 5:00pm so it will take inco consideration working hours and days?


Regards

Copy of Maintenance Example Forum.xlsHi XOR LX,

If you look at the attached spreadsheet it has your formula in column J as the resolve time which works it out great expect i was wondering if you could put the results in column J to work out the resolve time between Monday - Friday 9:00am 6:00pm as its a maintenance spreadsheet and we done work past 5:30pm and we dont work the weekends to the fact that column J arrives at a resolve time of after them days/hours it doesnt work.

Thank you again for ur help.

Copy%20of%20Maintenance%20Example%20Forum(1).xls Please see attached with what you asked for. Sorry I am not very good at explaining myself sometimes.

I have put some text in to describe what we require and some examples with comments in so show what the answer should be.

Thank you again for all your help.

Regards

Randomfluky