or excel
Posted By: NM on 2007-12-10
In Reply to: PS: If you excell at an area that is good for the company, why - MT
nm
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
?excel
On their ad it says Excel required. Is that just for timesheets? Thanks
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 logs and adding up job lengths (sm)
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.
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
|
