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.