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

On Sep 4, 12:28*am, Patrick <Patr...@discussions.microsoft.com> wrote:
> 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

another one:

=a1+time(0,30,0)


Patrick wrote:
>
> 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

--

Dave Peterson

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)


"Pete_UK" wrote:

> 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
>
> On Sep 4, 12:28 am, Patrick <Patr...@discussions.microsoft.com> wrote:
> > 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
>
>

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

On Sep 4, 1:17*am, Patrick <Patr...@discussions.microsoft.com> wrote:
> 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)
>
>
>
> "Pete_UK" wrote:
> > 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
>
> > On Sep 4, 12:28 am, Patrick <Patr...@discussions.microsoft.com> wrote:
> > > 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- Hide quoted text -
>
> - Show quoted text -