thanks everyone!
But i'm still having issues and need to explain much further in depth i think what i am trying to do might be too complex and its not as simple as i thought. i wanted to place my spreadsheet on here so everyone could see it but can not. first I have to do the html jeanie thing and saw the link on SAL's reply but in excel options:add ins: go: there is no little box for me to click to "tick" html jeanie option. GRRRRRR! im so frustrated.
I have been thinking of how to word this.
Sal's formula does work I see what he is saying, but it does not work the way i need it to.
if i enter that formula i can enter a start time right now and say that cell D8 was assigned at 1:00 PM and then F8 shows 4:40 because this ticket has been open/working on for 4 hours and 40 mins (because right now it is 5:40pm when I entered 1:00 PM into cell D8, so this is correct. so far this ticket has been assigned and opened for 4 hours and 40 mins. ... however, now it is 5:41pm and cell F8 still shows 4:40 ... so now this is wrong.)
I will be entering a time in cell D8 at the exact time the ticket is assigned.
If I need to look at this workbook in two hours from the time I assigned the ticket and entered a time into cell D8 then I need cell F8 to keep updating the time until a time is entered in cell E8.
If I went at the end of every day and entered data to store in this workbook this formula works. But I need it to be more of a interactive workbook. To where my manager at any time can pull this up and see how long,(how many days/hours/mins a ticket has been opened for.
So literally i need to create a timer in cell F8 that I guess some how coordinates with the time on my PC on the start bar.
I know this has to be possible because excel can due a calculation to automatically figure out the date when we enter =TODAY() and some tickets may only be open for minutes others may be open for days, so I need the formula to take this into consideration and it may say 76:34 to mean the ticket has been open for 3 days 4 hours and 34 mins.
I talked to a guy in my IT department and a friend and we are all trying to figure it out but obviously are not that advanced so..... who on mr. excel is the "ballin' brainiac who reins over us all"
and can figure this out because i know many of you here are.... and I just do not get this.... in way over my head !
The reason I need this formula so precise is because then next once this cell E8 has a time entered in it I then have another fun formula to where I have to add all the time in column F but only when there is a time entered in column E and there is a certain name in column B so then i know how much time total was spent by that employee working on the completed tickets for this particular day. .....
Any help is so appreciated.... because then even if it is not right but close at least hopefully it can help me figure this out. every time I think I got it i realize why it won't work the exact way my boss wants it to.
Thanks and much love to you all!!!