Glad to help!!! :-D




"Excel ??" wrote in message
...
WOW thank you i think this worked, this is what ineeded will try on
spreadsheet again...thank you SO MUCH
--
2


"Conan Kelly" wrote:

Excel ??,

Once again, I'm having a hard time trying to understand what you are
trying
to do. It sounds like you just described the exact same thing twice.

Try this out:

In A1 enter "8:30"
In A2 enter "9:15"
In A3 enter "=A2-A1"
(do not enter the quotes...just everything between quotes)
This should get you the time difference formatted as "h:mm"


You could also try this:
In A3 enter "=(A2-A1)*24*60"
(A3 will probalby auto format to some sort of time format, so you will
probably have to format the cell as a number format of some sort)

HTH,

Conan






"Excel ??" wrote in message
...
Conan THANK YOU...this is almost close this is what i'm trying to do
sorry..

ok in cell A1 I would like to enter 8:30AM in cell A2 I would like to
enter
9:15 and I need a total of minutes in cell A3? also is there away of
entering different times and having excel calcuate the total time enter
like
if i enter 8:30in cell A1 and 9:15 in cell A2 would Cell A3 give me the
total
I enter? I need something that will help me with a 45 minute agenda -
sorry
i'm learning all this stuff - THANK YOU SO MUCH
--
2


"Conan Kelly" wrote:

Excel ??,

I'm not quite sure what your asking, but does this help?

In cell A1 enter 8:00 AM, in cell B1 enter "=A1+TIME(0,45,0)", format
cell
as "h:mm AM/PM" or "h:mm:ss AM/PM" or whatever format you want.
In cell A2 enter 9:00 AM, copy/fill down formula from B1 to B2.

If that is not what you are looking for, please provide more
information:
sample data, cell addresses of data, desired results, cell addresses
of
where you want the results to be.

HTH,

Conan




"Excel ??" wrote in message
...
Hello All, do any of you have an Agenda that has function of a 45
minute
agenda starting at 8:00AM and 9:00AM... i really need something
like
this,
and i"m not good with time functions - I would like to enter the
time
and
have it set to a 45 minute meeting - THANKS YOU FOR ANYONE WHO CAN
HELP
ME!
--
2