Add time to a date time group

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

Hi, thanks for any help in advance

I have my date and time displayed in this format dd hhmm "K" mmm yy

which shows up as 03 1800 K Sep 08.

I would like a formula that will add 30 min to this time group so it becomes
03 1830 K Sep 08
 
Assume your date/time is in A1, then you can do this in another cell:

=A1+30/24/60

Format the cell in the same way as A1 (using the Format Painter icon).

Times are stored in Excel as fractions of a 24-hour day, hence the
divisions by 24 and 60.

Hope this helps.

Pete
 
another one:

=a1+time(0,30,0)

Hi, thanks for any help in advance

I have my date and time displayed in this format dd hhmm "K" mmm yy

which shows up as 03 1800 K Sep 08.

I would like a formula that will add 30 min to this time group so it becomes
03 1830 K Sep 08
Click to expand...
 
Thankyou that helped, I am still haveing some problems in this worksheet
though, the next problem is I need to calculate the time differance between 2
date time groups and add it to another, for example

I have a tme line, lets say I have a meeting that is going over time, once I
have entered the change in time I need it fint the time differance in cell A1
and B2 and add it to cell A3
A1 B1
03 0730 K Sep 08 03 1000 K Sep 08 (morning meeting)

A3
03 0830 k Sep 08 (Breakfast)
 
I'm not sure what you want here, or what your example is trying to
show. It looks like you have a meeting from 7:30 am to 10:00am, and
you have breakfast at 8:30 am. Are you trying to subtract the length
of time your breakfast took away from the total duration of the
meeting to get the real duration of the meeting? If so, where do you
record the duration of your breakfast?

Or, are you saying that because the meeting runs from 7:30 to 10:00am,
your breakfast has to be rescheduled from 8:30 to the time your
meeting finishes?

And where does B2 come into it?

Pete
 
Back
Top