PDA

View Full Version : Solved: Help showing end date and time.



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

RichardSchollar
10-30-2008, 03:33 AM
Hi

You could just use a formula like:

=A1+B1+C1

in both D and E and format D as:

dd mmm yyyy

and E as:

hh:mm:ss

Alternatively in D:

=INT(A1+B1+C1)

formatted as dd mmm yyyy

and in E

=MOD(A1+B1+C1,1)

formatted as

hh:mm:ss

Richard

Ryu
10-30-2008, 05:00 AM
Thanks Richard