|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 3rd, 2005, 08:14 PM
|
|||
|
|||
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
November 3rd, 2005, 10:57 PM
|
|||
|
|||
|
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
November 14th, 2005, 10:12 PM
|
|||
|
|||
|
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
November 14th, 2005, 10:14 PM
|
|||
|
|||
|
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
November 14th, 2005, 10:24 PM
|
|||
|
|||
|
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
December 19th, 2005, 08:31 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Time Zone suggestions for Outlook Calendar | Ben Knox | Calendar | 2 | October 20th, 2005 03:42 PM |
| Please Help! Ref Article ID 210504 | Telobamipada | New Users | 8 | May 9th, 2005 01:09 PM |
| Calculating Time (Like in a Timesheet) | Leonard Peacock | Using Forms | 14 | March 24th, 2005 02:49 PM |
| Calculating time on a time card | Kevin | General Discussion | 1 | January 10th, 2005 06:23 AM |
| calculating negative time differences | michelle selby | Worksheet Functions | 2 | September 20th, 2003 09:22 PM |
Linear Mode
