| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculating time
Hello, I am totally new to excel and I've been handed an availabilities spreadsheet to maintain. Can someone help me figure out how to write a formula that will give me the total minutes per month for the years 2003/2004 and 2005. This is the information I received -----** The total number of minutes in month (28, 29, 30, or 31 days *1440 min/day) minus the sum of planned downtimes------ and also this formula which doesn't work------=(EOMONTH(A37,0)-A37+1)*1440-------- with the explanation that AXXis the column representing the month-year. Keep in mind that I have NEVER worked in excel before. Any information will be GREATLY appreciated!!!!!!!!!!!!!!!!!!!!!! Thanks, Bizyb  -- bizyb ------------------------------------------------------------------------ bizyb's Profile: http://www.excelforum.com/member.php...o&userid=28539 View this thread: http://www.excelforum.com/showthread...hreadid=482010 |
|
#2
|
|||
|
|||
|
calculating time
Hi!
this formula which doesn't work------=(EOMONTH(A37,0)-A37+1)*1440 What does "which doesn't work" mean? If A37 is the FIRST day of the month and is a true Excel date formatted to display as month-year then the formula DOES work. For example: The true value of A37 = 1/1/2003 but it's formatted to display as Jan-03. Biff "bizyb" wrote in message ... Hello, I am totally new to excel and I've been handed an availabilities spreadsheet to maintain. Can someone help me figure out how to write a formula that will give me the total minutes per month for the years 2003/2004 and 2005. This is the information I received -----** The total number of minutes in month (28, 29, 30, or 31 days *1440 min/day) minus the sum of planned downtimes------ and also this formula which doesn't work------=(EOMONTH(A37,0)-A37+1)*1440-------- with the explanation that AXXis the column representing the month-year. Keep in mind that I have NEVER worked in excel before. Any information will be GREATLY appreciated!!!!!!!!!!!!!!!!!!!!!! Thanks, Bizyb -- bizyb ------------------------------------------------------------------------ bizyb's Profile: http://www.excelforum.com/member.php...o&userid=28539 View this thread: http://www.excelforum.com/showthread...hreadid=482010 |
|
#3
|
|||
|
|||
|
calculating time
In the cell is the error #NAME? instead of a number. -- bizyb ------------------------------------------------------------------------ bizyb's Profile: http://www.excelforum.com/member.php...o&userid=28539 View this thread: http://www.excelforum.com/showthread...hreadid=482010 |
|
#4
|
|||
|
|||
|
calculating time
Hi Biff, in the cell is the error #NAME? instead of a number Bizyb Biff Wrote: Hi! this formula which doesn't work------=(EOMONTH(A37,0)-A37+1)*1440 What does "which doesn't work" mean? If A37 is the FIRST day of the month and is a true Excel date formatted to display as month-year then the formula DOES work. For example: The true value of A37 = 1/1/2003 but it's formatted to display as Jan-03. Biff "bizyb" wrote in message ... Hello, I am totally new to excel and I've been handed an availabilities spreadsheet to maintain. Can someone help me figure out how to write a formula that will give me the total minutes per month for the years 2003/2004 and 2005. This is the information I received -----** The total number of minutes in month (28, 29, 30, or 31 days *1440 min/day) minus the sum of planned downtimes------ and also this formula which doesn't work------=(EOMONTH(A37,0)-A37+1)*1440-------- with the explanation that AXXis the column representing the month-year. Keep in mind that I have NEVER worked in excel before. Any information will be GREATLY appreciated!!!!!!!!!!!!!!!!!!!!!! Thanks, Bizyb -- bizyb ------------------------------------------------------------------------ bizyb's Profile: http://www.excelforum.com/member.php...o&userid=28539 View this thread: http://www.excelforum.com/showthread...hreadid=482010 -- bizyb ------------------------------------------------------------------------ bizyb's Profile: http://www.excelforum.com/member.php...o&userid=28539 View this thread: http://www.excelforum.com/showthread...hreadid=482010 |
|
#5
|
|||
|
|||
|
calculating time
You need to install the ATP add-in, look under toolsadd-ins and select ATP
(Analysis ToolPak), keep the office/excel cd handy and follow the instructions -- Regards, Peo Sjoblom "bizyb" wrote in message ... Hi Biff, in the cell is the error #NAME? instead of a number Bizyb Biff Wrote: Hi! this formula which doesn't work------=(EOMONTH(A37,0)-A37+1)*1440 What does "which doesn't work" mean? If A37 is the FIRST day of the month and is a true Excel date formatted to display as month-year then the formula DOES work. For example: The true value of A37 = 1/1/2003 but it's formatted to display as Jan-03. Biff "bizyb" wrote in message ... Hello, I am totally new to excel and I've been handed an availabilities spreadsheet to maintain. Can someone help me figure out how to write a formula that will give me the total minutes per month for the years 2003/2004 and 2005. This is the information I received -----** The total number of minutes in month (28, 29, 30, or 31 days *1440 min/day) minus the sum of planned downtimes------ and also this formula which doesn't work------=(EOMONTH(A37,0)-A37+1)*1440-------- with the explanation that AXXis the column representing the month-year. Keep in mind that I have NEVER worked in excel before. Any information will be GREATLY appreciated!!!!!!!!!!!!!!!!!!!!!! Thanks, Bizyb -- bizyb ------------------------------------------------------------------------ bizyb's Profile: http://www.excelforum.com/member.php...o&userid=28539 View this thread: http://www.excelforum.com/showthread...hreadid=482010 -- bizyb ------------------------------------------------------------------------ bizyb's Profile: http://www.excelforum.com/member.php...o&userid=28539 View this thread: http://www.excelforum.com/showthread...hreadid=482010 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculating time
Thanks Peo Sjoblom It worked like a charm. GREAT TIMING - getting this working made me look good for my performance review. I had asked our 2 "resident experts" on two different occasions with no response. You are very much appreciated. Thanks again bizyb :) :) -- bizyb ------------------------------------------------------------------------ bizyb's Profile: http://www.excelforum.com/member.php...o&userid=28539 View this thread: http://www.excelforum.com/showthread...hreadid=482010 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
| Time Sheets | New Users to Excel | |||
| Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
| time differences in a column | Excel Worksheet Functions | |||
| calculating with a time format cell | Excel Worksheet Functions | |||
Linear Mode
