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
coreybryantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Michael FowlerSolutions 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
http://www.cpearson.com/excel/datetime.htm

Michael
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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?
0
jack__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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.