 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006Need Help creating a formula****PLEASE
I am a manager in a big office where agents log into their phones to get calls. We keep track of how many minutes an agent is "logged off" of their phone system. I would like to be able to have a formula to use in Excel to speed up the calculations for this info. Here is what the info looks like that I am given and what I need to calculate: Sunday, December 03, 2006 Agent Login Time Logout Time # of minutes logged out Doe, Jane 6:58am 8:51am (need to find # minutes from 9:39am-8:51am) Doe, Jane 9:39am 2:30pm (need to find # minutes from 2:30pm-2:34pm) Doe, Jane 2:34pm 3:29pm (need to find # minutes from 3:29pm-4:15pm) Doe, Jane 4:15pm 5:00pm I cannot seem to get a formula to work that will calculate the time Pamela, Use this formula: =((HOUR(B1)*60)+MINUTE(B1))-((HOUR(A1)*60)+MINUTE(A1)) David Miller > I am a manager in a big office where agents log into their phones to > get calls. We keep track of how many minutes an agent is "logged off" [quoted text clipped - 14 lines] > > I cannot seem to get a formula to work that will calculate the time Thank you very much, but I must still not be doing this right. I copied formula and changed the B1 and A1 to the correct cell values, but the output is showing #VALUE!...what am I doing wrong? Thank you again for assisting me... > Pamela, > [quoted text clipped - 22 lines] > > > > I cannot seem to get a formula to work that will calculate the time =B4-C3 and format as time  Signature--- HTH Bob (change the xxxx to gmail if mailing direct) > Thank you very much, but I must still not be doing this right. I > copied formula and changed the B1 and A1 to the correct cell values, [quoted text clipped - 28 lines] >> > >> > I cannot seem to get a formula to work that will calculate the time Hi Pamela, as long as your login and logout values are actually formatted as times (i.e. you haven't written the 'am' and 'pm' manually) then you should simply be able to subtract the login time from the logout time... e.g. =C2-B2 Excel should automatically format the result as hh:mm. If you get a fractional result such as 0.1458333 then this hasn't happened and you will need to set the formatting of the result yourself. HTH, NickH > I am a manager in a big office where agents log into their phones to > get calls. We keep track of how many minutes an agent is "logged off" [quoted text clipped - 14 lines] > > I cannot seem to get a formula to work that will calculate the time Ah, there I go jumping the gun again. If it's simply a question of finding the total number of minutes without showing them as 'hours and minutes' just change the cell formatting to [mm]. Yes, include the square brackets. ?;^) NickH.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.