adding time to current time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George - 12 Oct 2004 19:45 GMT

All,

I am looking for a way to get the time in one field to add 6 hours to that
time field when it is from another country. Any thoughts on how to do this
as I am new to this coding in Excel?

My current time selection is this 4:58 AM and I would like to add 6 hours to
each field like that?

Reply to this Message

JulieD - 12 Oct 2004 19:48 GMT

Hi George

=A1+6/24

Cheers
JulieD

> All,
>
[quoted text clipped - 6 lines]
> to
> each field like that?

Reply to this Message

George - 12 Oct 2004 20:06 GMT

Julie,

That works but how do I put that into a cell where the time already is?
Thank you BTW for the quick answer!!!

George

> Hi George
>
[quoted text clipped - 13 lines]
> > to
> > each field like that?

Reply to this Message

George - 12 Oct 2004 20:18 GMT

Never mind I figured it out. Sorry for the illiterate question :-)

> Julie,
>
[quoted text clipped - 21 lines]
> > > to
> > > each field like that?

Reply to this Message

JulieD - 13 Oct 2004 02:06 GMT

hi George

glad its solved & thanks for the feedback.

Cheers
JulieD

> Never mind I figured it out. Sorry for the illiterate question :-)
>
[quoted text clipped - 24 lines]
>> > > to
>> > > each field like that?

Reply to this Message