Date and Time in Excel

I am trying to figure out how to get Excel to show dates and times and also add those.

I would get one cell that would say 2-Jul-13 22:45PM and I would copy that cell over.  I would change it to 3-Jul-13 03:32AM and it would show up as 00:00 in the cell.

I am trying to build the spreadsheet something like
1-Jul-2013 22:00 1-Jul-2013 22:45  2-Jul-2013 03:45  2-Jul-2013 13:00 2-Jul-2013 14:00

and then 1-Jul-2013 22:45  2-Jul-2013 03:25  and 2-Jul-2013 13:25 2-Jul-2013 14:25 would be added up to 8 hours (1-Jul-2013 22:45  2-Jul-2013 and 2-Jul-2013 13:00 2-Jul-2013 14:00) - I used and easy time to give you an idea.

It would repeat on the next line
2 Jul 2013 and then times etc.
LVL 29
Who is Participating?
Michael FowlerConnect With a Mentor Solutions ConsultantCommented:
You can format the cells to display the date and time in the format of your choice

Here is a good link outlining how date/times work in Excel

coreybryantAuthor Commented:
Thanks - let me take a look at it.  I am needing to add the date / time and then have it be added together.  

For example:
3 Sep 2013 22:34   4 Sep 2013 0435

Would it be best to keep everything in the same cell?
jack__Connect With a Mentor Commented:
it's best to keep date and time in the same cells as it makes computation easier.

you can also change how the date is shown by using the TEXT function.
=TEXT(cell reference,"d MMM YYYY h:mm")

or press  just press CTRL+1  
click "custom" and paste or type d MMM YYYY h:mm into window
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.