Excel logs and adding up job lengths (sm)
Posted By: tnmt on 2008-01-26
In Reply to:
This is for the MTs who have to keep an Excel log for jobs and need to add up the minutes transcribed at the end of the day.
I've done some footwork today and discovered a Microsoft page which tells you how to enter times into cells: http://support.microsoft.com/kb/266691
I haven't figured how to automate it, but basically Excel recognizes minutes and hours if entered in the following format: hh:mm:ss. So if you have a 5 minute 12 second job, you would enter 00:05:12 in that cell. Then at the end of the day you enter the formula =Sum and the cell range (the link gives specific example) and it adds up your minutes and seconds automatically for you.
I thought I'd share. I've been adding my account by hand because I didn't know how to sum with minutes and seconds till now.
Complete Discussion Below:  marks the location of current message within thread
The messages you are viewing
are archived/old.
To view latest messages and participate in discussions, select
the boards given in left menu
Other related messages found in our database
meant increased line lengths.
x
logs
Logs were required and not that long ago.
logs
yep - on some accounts they sure are required, know that for sure, and it does take time, but doesn't bother me
We do not keep handwritten logs at all. I don't think that
any of the leads require it. I just checked with a few of the others that I know that work for KS too and they do not either.
You must not be one of us who logs on their assigned shift only to be told...
to stay off the system as the work is too low. Nice thought though. I'd really LIKE to do my job when I am supposed to but I have no control over when they tell us ot stay off until the afternoon and you sit there prayer there will be work then.
?excel
On their ad it says Excel required. Is that just for timesheets? Thanks
or excel
nm
anyone know anything about Excel Transcription? TIA! nm
.
Any information on Excel transcription?
Pay is very low but no weekend work and not married to the computer for hours at a time, does anyone know anything about this company?
Could it be done in an Excel file and attached?
I have to send an Excel log with my secondary account, and I created a column with a formula that sums up my line count so I don't have to add it up. I keep it open while I'm transcribing and toggle over and record the information rather than writing it down, then at the end of the day I just have to delete the unused cells, highlight my totals, then attach it to an email. Seems like that would work well for what you're describing.
More on Excel date/time
Sounds like you don't mind doing it, but if you're curious - check your formatting.
Go to the cell in question, then use the menu: Format > Cells
Make sure the format is GENERAL then close the dialog
Then type in 5:03 (or any time with just m:ss)
Also, try to type this in: 4:63 -- see what Excel changes it to
Good luck Excelling!
Make yourself an Excel sheet to do the calculations for you.
Not hard to do.
Once I get my packet, I'm going to do that. If you want I'll post when I do that and would be glad to send it to those who want it.
Excel date/time value vs. format
It's helpful to understand how Excel handles date/time. (In all examples below, you don't actually type the quotes)
Excel maintains a distinction between the VALUE of the date/time and the FORMAT. For instance, when you type 5:12 in cell A3, Excel understands that you mean a date/time value, and stores this as 0.2166666. By default, if you do not specify a date, Excel uses the mythical 1/9/1900 for the date portion, and the time specified.
As another example, go to any cell and type in =NOW(). Excel will store this as a date/time, but format it on screen to your default preference -- mine looks like 1/26/2008 14:23. But if you click on that date again, then go to the Format menu, choose Number, select 4 Decimal places, you will see it change to 39473.6000 -- representing 39473.6 full days from the beginning of time (according to Excel - 1/0/1900).
Bottom line: go ahead and enter your data as just h:mm, then add them up / see if it behaves -- shouldn't require any special formatting....
Also, fwiw - if you have any Excel questions, I would be happy to reply here or answer emails....
Anyone work for Excel Transcription out of IL - send me an e-mail nm
nm
I'm fairly new to KS, but I know they are adding
2 new accounts by February, so there should be lots of work. The account I am on is fairly new and still working out all the kinks, but right now there is a lot of work available on it too, so you might want to talk to your lead or Lee and ask for more work.
Adding a question to yours...
do they pay hourly or by the line for QA?
Sorry. I was just adding to the insults.
I was also offering my own experience with my particular company. He was pointing out the expenses of the MTSOs and I was pointing out the growing expenses of the MT. In other words, I was sharing my viewpoint as well.
...all this "stuff" should be in there. I keep adding to it as changes are made, etc. nm
s
If you try adding more than one time the ESP screen
will be behind your other screens. If you minimize them you will see it.
are you adding your names/addresses into
your abbreviation file so you don't have to look up the same name/address twice? That is what I do. With an MD with multiple locations, I will name it something like SmithDown for Dr. Smith, Downtown or JonesLake for Dr. Jones at Lake Forest. You would still have to cut and paste some in the cc field or you might ask operations if there is a way to build a spreadsheet document and add to it as you come across new names/addresses.
Adding, you do have to work the shift SM
you commit to. If you are wanting flexibility as far as being able to leave in the middle of a shift and make up the time later, you would have to negotiate a split shift with them in the beginning and see if they would go for that. As far as my experience goes, I did 8 hours with a lunch break and turned in 40 hours per week. I'm sure if there was an emergency I could have flexed my time for 1 day but if you need flex time every day for picking up kids, etc. you should mention that in the interview and see if they can accommodate. Once you commit to a schedule it is difficult to get it changed.
what do you mean "toggle over." and what is your formula for adding it up? Help!
nm
Awesome! Thanks for adding to the list!
Really appreciated!
Adding insult to injury
My coffee cup came apart in the dishwater today.
Yes, still hiring. They are adding two more hospitals before the end of the year and are looking
for like another 30 or 40 MTs.
...and perhaps adding a statement to contract before signing
outlining course of action (fines, etc.)in the event. If they have a problem with that - well...
Why is it we do not have our own contracts to present to companies? Two areas of concern - guarenteed work and failure to pay.
Line padding. adding extra words.
x
We will be adding that feature back, we are just in transition of migrating over to our newer
version of the forum software. We appreciate your patience. 
I wonder what the quality of the work is like adding all those people to accounts. I agree. They
will lose accounts this way and MTs will move on. No one is going to sit around and make no money and then have QA breathing down your neck when you are thrown into all these accounts. So no one listens in New York. What is the problem with them.
What I read was that they opened a center in India BUT were adding work for them and keeping their
domestic work force as well.
|
