98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Date and time
Date and time
Resolved · Low Priority · Version 2007
Jaimie has attended:
Excel Intermediate course
Date and time
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
RE: date and time
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |