how do I add 3 hours to a time?

[hamiltoncruiser]

I have the baseball schedule in cvs format for import into Outlook.

How do I change the end time? I want it to be 3 hours after the start
time.

START_DATE START_TIME START_TIME_ET SUBJECT LOCATION DESCRIPTION
END_DATE END_TIME END_TIME_ET
14/04/2008 7:05 PM 7:05 PM Blue Jays at Orioles Camden Yards
4/14/2008 7:05 PM 7:05 PM

The start time is in a custom format of h:mm AM/PM

Thanks!

....Lisa

 

[Tyro]

Formats have nothing to do with time. Or anything else. Formatting is used
to display things.
If you wear a blue suit today, that is your format for today; if you wear a
grey suit tomorrow
that is your format for tomorrow. In both cases it it still you.

Excel uses numbers to represent dates and times. Jan. 1, 1900 is day 1, Jan.
2,
1900 is day 2. Jan. 1, 1950 is day 18,264. Jan. 1, 2008 is day 39,448. Jan.
1, 2009
is day 39,814. A fast way to see the date serial number for a date is to
enter
the date in a cell then press Ctrl+Accent grave (`) - the key above tab and
left
of the 1 key Press Ctrl+Accent grave again to return to normal. Excel uses
the
numbers 1 (Jan. 1, 1900) through 2,958,465 (Dec. 31, 9999) to represent
dates. Is a number a number or a date? It depends on how you interpret it.
You can use those numbers for calculations or format them as dates. If you
have
entered a date and time, Excel stores the date as the integral part of the
number
with the time as a decimal fraction. For example if I enter: Jan 1, 2008
12:00 PM
Excel stores that as 39448.5 where the day is 39,448 and the time is .5
representing:
24 hours * .5 = 12 - noon. Excel's times start with 0.0 representing 12:00
AM
- i.e. midnight. So if you enter Jan 1, 2008 9:31 AM Excel stores that as:
39448.396527778. 24 hours * .396527778 = 9.516666667 hours, which is 9:31 AM
If you enter 3:00 AM, no date, Excel stores that as 0.125 (3/24). The 0
represents
the fictitious date of Jan. 0, 1900. If you enter 3:00 PM, Excel stores that
as
0.625 (15/24). Dates and times are just numbers. Formatting those numbers as
dates
and times is for visual display. Many people confuse the formatted value in
a
cell with the value in the cell. When you format a cell, Excel does not
change the
value in the cell; Excel simply displays the value in the cell in the way
you want
to see it.

If you wish to increment a time by 3 hours, and the time is an Excel time,
simply add 3/24 to the time.

Tyro

 

[BoniM]

start time + 3/24
or
start time+ 0.125
if you prefer the decimal equivalent
format the same as your start time

 

[Fred Smith]

I always use:

=a1+time(3,0,0)

because it's clearer to me that I'm adding 3 hours, 0 minutes and 0 seconds.

Regards,
Fred.

 

[hamiltoncruiser]

Thanks so much everyone!

I was able to change the time on the spreadsheet, imported into
Outlook and it still imported the events as 1 hour events..didn't do
what I wanted. (
I know Outlook is OT here...but any suggestions? Email is good if you
don't want to clog this NG with OT messages. Thanks!!

...Lisa