Ryu
10-30-2008, 03:30 AM
Hi People
I was hoping someone could offer me some help please on my excel file. What I require is pretty simple but at the same time it?s a little bit annoying.
So basically I have three columns in my excel file,
Column A has a date,
Column B shows a start time,
Column C shows an elapsed time (time it takes for the action to finish)
Now the help I need is to add column D and E.
Coolumn D ? I want to show the end date, so for example if the date is 28/10/2008 and the start time is 22:00:00 and the elapsed time is 04:00:00 in column D I want to show 29/10/2008
Column E ? I want to show the end time, so using the above example in column E I want it to display as 02:00:00
Is this possible? Thanks
I was hoping someone could offer me some help please on my excel file. What I require is pretty simple but at the same time it?s a little bit annoying.
So basically I have three columns in my excel file,
Column A has a date,
Column B shows a start time,
Column C shows an elapsed time (time it takes for the action to finish)
Now the help I need is to add column D and E.
Coolumn D ? I want to show the end date, so for example if the date is 28/10/2008 and the start time is 22:00:00 and the elapsed time is 04:00:00 in column D I want to show 29/10/2008
Column E ? I want to show the end time, so using the above example in column E I want it to display as 02:00:00
Is this possible? Thanks