Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! time on a 45 minute Agenda
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! time on a 45 minute Agenda
adding .0315 to a time will add 45 minutes
(format the cell time to get rid of the date part) "Excel ??" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! time on a 45 minute Agenda
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 -- 2 "dlw" wrote: adding .0315 to a time will add 45 minutes (format the cell time to get rid of the date part) "Excel ??" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! time on a 45 minute Agenda
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! time on a 45 minute Agenda
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! time on a 45 minute Agenda
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! time on a 45 minute Agenda
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! time on a 45 minute Agenda
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get time elapsed in terms of minute? | Excel Discussion (Misc queries) | |||
Formula for agenda to create start/stop with projected time of ev | Setting up and Configuration of Excel | |||
Agenda Time Formula | Excel Discussion (Misc queries) | |||
Using time formats in minute units | Excel Discussion (Misc queries) | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) |