Excel date/time value vs. format
Posted By: Excel guru on 2008-01-26
In Reply to: Excel logs and adding up job lengths (sm) - tnmt
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....
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
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!
It's not that the pay is never on time, it's just that they don't give you an exact date; o
xx
?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.
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.
Anyone work for Excel Transcription out of IL - send me an e-mail nm
nm
Format
The program is very easy to learn - literally only takes a few minutes. The daily line count really depends on your typing speed. My speed is not what it could be because I have a 6yo at home with me and have several interruptions during my shift with dinner, ball practice, etc. But, on a good day with no interruptions, I would say a minimum of 1000 lines. No need to apologize for the questions. Feel free to ask all the questions you want. It's better to know what you're in for before you jump in head first with any company!
It does not format everything according to sm
specs. Many times, no headings are made, things are not spaced the way the account wants it to be.
Do not believe the lies they are telling you. I work on it now and it does not do what they are telling you it does.
I mean platform, not format
.
It's all in the margins and format
when comparing a gross line count to a character count, but my goodness, .23 a line sounds like it cannot possibly be true. My gross lines accounts don't convert that way at all. One doc has a 1-inch margin and her gross line count is just slightly above the 65-character count because she doesn't do lists and keeps her PX in paragraph format. If you are being told it converts to .23 a line, I would wonder if most of the whole report is indented half-way across the page. Maybe you hit upon a gold mine! Ask about the format...
I have to put that leading 0 and use h:mm:ss format
or it doesn't add correctly, but yeah, I found on playing with it that I could just enter them in that way, then do a sum and it added up just fine without any special formatting or customizing cells.
And, thanks for the information and the offer. Most of the time I don't know enough to even know what question to ask. I just made that discovery and thought I'd throw that out there in case somebody else was in the same boat. :)
I did not see any format rules.
As far as reformatting, I use macros to make formatting changes that seem to be frequently necessary.
You can format Shorthand to...sm
put the ctrl+n keystroke into your text. You don't have to go back and reformat the headers that way.
MDI-MD resume format question
I sent them a resume a couple of weeks ago, but it was in word perfect format. Should I have converted it to a .doc file?
Do you have a copy of the BOS to follow for format, etc.? nm
s
How about providing some samples of format? sm
OK, so transitioning can be tough, but for an MT with that kind of experience, I would assume that with a few samples of format to follow she could be up and running in no time. I would not mess with them. Something is weird.
Thank you! What is the format like, and is it timed? Any info helpful please. Thanks! nm
nm
Does it format for a SSN - can you put in a note that you will provide it if hired? nm
nm
Just paste it and let it go. They're looking for content, not format, when ....sm
...the resume is sent via a web contact form. If you are a good MT with good qualifications, they won't care how it's set up, but do make sure words are spelled correctly. That's a huge bugaboo when I read resumes.
You will have to completely format the hard drive first
delete any partitions and create a new partition, format the C drive and then install Windows XP. I have done this a ton of times and have had no problems.
Clinic notes. SOAP is the format,
subjective
objective
assessment
plan
I totally agree re medical report format.
x
The date
Did you notice that the date on the postings shows 03/04? That's strange, too. Where I live, in the USA, it is still 03/03.
You do not have to put your date of birth on
an application. It is illegal for them to ask age so date of birth falls in line. If you want to just provide the month and day, that's okay. The only time you would have to give date of birth or anything age related would be after you get the job and I can't really think of a reason they would need that. They would probably find it out on your driver's license for identity purposes but other than that, I see no reason to let them have it prior. Social security number again is a sensitive issue for application purposes only. When you get the job of course you do HAVE to give it whether you are employee or IC. I just would not randomly provide them with this information until you are hired and if they don't like it, they do not have to.
Did you check the date (m)
on the ad? The one I found for them on MT stars is from 2003. May not be around anymore.
Just had not said anything to date, but getting concerned. n/m
d
Anyone with up to date info re TRS?
What is the most up to date info on TRS? Good or bad? I read an old archives that said they deduct lines from you pay if client gets a report with errors. Also read that it is hard to get lines with their platform. Need the most current info regarding this company. Thank you.
Can someone tell me a little something up-to-date about these companies. nm
:
start date?
anybody been contacted for a new start date?
My bad. Pay date the last day of the month,
not the 30th.
IMPORTANT DATE
Another poster just indicated the date of the official merge is September 1st.
I just wanted to point this out so anyone intending to take a stand could make August 31st, 2009, their last date of employment for MDI-MD.
Closing date is 08/31 but there's a 15-day
nm
Anyone know of a company, easy clinic work, easy Word format, dependable pay? Help!
x
I have work, all on today's date.
xx
So, the ad was still posted after your cutoff date? sm
How tacky is THAT?
Any up-to-date info on Transcend?
Archives from 2005 bring up a lot of problems with platform going down. Is this still the case? Is pay on time? TIA.
scroll to posts from the date
03-03-2007. Theye are posts from management regarding PT issue.
Can you restore to an earlier date and get (sm)
the changes the techie made to your computer? I had 2 different companies set me up with an e-mail addy for their company, and got scam stock e-mails. I feel your pain.
Need up-to-date info for Medware?
I am thinking about working for them, but need current info as far as flexibility, etc.
TIA
Do ctrl S then search by your ID # and the date.
Then you can compare job #s but only if you're writing down the document ID and not the voice job ID.
Not sure if this list is up to date or if a fee is charged, but here's
Diskriter, Precyse, Opti-Script (Penn.), CIT (Charts in Time, FLA.), WebMedX, Transcend, Trans-Tech?, MQ?, Spheris, and Amphion.
Would really like any up-to-date info on Transcend.
thanks.
Need up-to-date info on DTS America
Such as platform, incentive plan if any and how does it work, benefits such as health insurance premiums, minimum line requirement, etc
Anybody know the exact start date of the
It's not the start date that's always the problem...sm
 If they give you a start date and not put you on 100% QA right away...OK. If they put you on 100% QA and give you guaranteed hourly minimum while you're in training, that's OK, too. But what about the ones that put you on QA until their own QA monitor (who may be required to given feedback on everything and also have to justify his/her job and sometimes nitpicks just a little too much  )...and who will not let you do more than 2-5 jobs a day until you're off of QA?
Up to date info on Deventure....Please....NM
NM
When someone says it is my PAY DATE, I expect that to mean the day I am paid. sm
And like the poster above, every other place I have worked, if the pay day falls on a weekend, I got the pay the day before.
Congrats to you for being so quick to defend. I didn't attack the company. I only said I wanted to have a pay day I could count on. If you cannot understand that, then I'm sorry you have no compassion.
And yes, they have grown quickly, perhaps TOO quickly. They make promises to the clients without having the manpower to back it up. Then they do a massive overhiring and then the work dries up. It is a great cycle -- flooded with work, or begging for it.
I do not have to defend myself. I stand by what I said.
|
