i dont suppose you know anything about formating cells in exel. I want to add two formulas in one cell. Is this possible. and how do i do it. One of the formulas is to auto calculate for example in a1 which is day 1 the finish time is 18.00. in b1 which is day 2 the start time is 9.06, so how would i write the formula to calculate the total time in between these times and the other formula is to add hours to a monthly total. this is why i need both formulas in the cells.