Need Help creating a formula****PLEASE


P

PamelaB

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
 
Ad

Advertisements

D

Dave Miller

Pamela,

Use this formula:

=((HOUR(B1)*60)+MINUTE(B1))-((HOUR(A1)*60)+MINUTE(A1))

David Miller
 
N

NickH

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
 
N

NickH

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.
 
P

PamelaB

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...
 
Ad

Advertisements

B

Bob Phillips

=B4-C3

and format as time

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top