HELP! time on a 45 minute Agenda

[Excel ??]

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!

 

[dlw]

adding .0315 to a time will add 45 minutes
(format the cell time to get rid of the date part)

 

[Excel ??]

sorry but what do i put on the cell? like what's the formula etc.. like if I
put 8:30AM in one cell and 9:15 on another what's the formala to calculate
this or how do I add the 0.315?? where do i do this...i really appreciate this

 

[Conan Kelly]

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 ??]

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

 

[Conan Kelly]

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 ??]

WOW thank you i think this worked, this is what ineeded will try on
spreadsheet again...thank you SO MUCH

 

[Conan Kelly]

Glad to help!!! :-D

WOW thank you i think this worked, this is what ineeded will try on
spreadsheet again...thank you SO MUCH