If I set up two cells with dd/mm/yyyy:hh/mm and subtract one from another, how can I get the answer to display in the same format or number of days:hours:minutes and not just as xx.xx days?

Thanks

Hi Jaimie, Thank your for your post, welcome to the forum, in answer to your question; this is a formatting problem, you must change the answer cell format to that which you require ie dd/mm/yyyy hh:mm right click on the cell, choose Format and Choose the Number tab, Select Date and make your choice from the options available, or go to Custom and type your required custom format. A quick fix would also be to click on one of your previously set up cells, then to click the Format Painter button (little yellow paintbrush) on the Standard toolbar and then click on the cell with the number in it, thereby changing its cell format. I hope that has helped, if so please click the Resolved link, best regards Pete