Get instant live expert help on time and date display
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
When I enter a date in the format 02-02, my Excel 2013 sets the date to 02-Feb. I need it to display Day-Month-Year in the format 01-01-****, can someone tell me how to change it so it will display this date all the time on all worksheets?
Solved by D. F. in 25 mins
Need help with date and time calculator. I need to calculate time in hours before surgery from a date and time of surgery and date and time of injury
Solved by K. C. in 18 mins
A formula is needed that will look at a row, find the most recent date out of multiple in dates in the row, and then display the cell that is to the left of the most recent date.
Thank you so much for your time,
Blake
Solved by T. D. in 29 mins
How do I set up a column in Excel to display 'age next birthday',
given birth date and today's date?
Solved by M. Q. in 23 mins
Hello
I would like to know if the following conversion is possible in excel
in cell 1 I have date and time information
currently formatted from the cell format menu as (dd/mm/yy hh/mm)
in cell 2 I have the number of minutes that a process will take - this number is usually around 2,000 - 3,000 minutes
in cell 3 is it possible to display the completion date and time of the process?
Solved by S. J. in 11 mins