Correction - sorry for confusion
Posted By: Excel guru on 2008-01-26
In Reply to: More on Excel date/time - Excel guru
I apologize for not checking this before -- I just found a problem with my suggestion, so here's the deal:
You are better off forcing the format - as you did to h:mm:ss (or hh:mm:ss), to ensure that all cells display consistently. This does force you to have to enter more digits for hours though.
There is a shortcut for entering data -- for 00:05:12 (5 minutes, 12 seconds), you can type: 0:5:12
For 00:05:01 you can type 0:5:1
This may be more foreign than just adding the extra leading zero, but if you're hyper about cutting every keystroke, you can....
Then when you add down a column, there's nothing special to do in the sum.
Sorry for any confusion.
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
Sorry for the confusion
I don't work for FN. Just thought they were asking about what rad MTs make in general. I work for a hospital, and no we are never out of work, but if that were to ever be the case, we would make our downtime rate.
There seems to be name confusion. Does TTS
stand for something?
Name confusion
There is definitely some name confusion going on here. TT and TTS are two different companies. I think a lot of people are getting the two confused. TT as far as I have heard is a great company to work for. TTS is the one to run far far away from.
There seems to be a lot of confusion there. SM
At least, more so than usual and many of us have a sick feeling that something is going to happen and it will not be good.
I would not encourage anyone to join the company, at this point. This uneasiness may be going on at other companies, it may be sign of the times concerning MT, but it is very strong at Spheris.
confusion
In the next few months, when I move, I may switch from working in hospital setting to working at home. I have been doing Radiology, Radiation therapy, EEG's for 16 years. Questions: what are the acute care four basics, and could radiology be one of them? Also, at hospitals we go by minutes. Unsure of how much I type that would be judged by lines. Any people here, or companies, strictly Radiology?
SPI confusion
How do they announce these things to employees? I've been with them 1-1/2 years and the branch I work for never seems to be affected by all the turmoil I hear about. I know there was a managers' conference in Nashville a couple of weeks ago but my supervisor has not sent out any layoff announcements or other bad news thus far. If you get laid off officially, can you qualify for unemployment? Thanks.
SPI confusion
The only email I got last week was one advising that we'd all be paid on the same Fridays, instead of some MTs being paid on the alternate Fridays, and how to make the switch regarding our production sheets. SPI is also running 2 ads in Advance magazine for new MTs. The hiring versus layoffs issue is confusing to me!
Confusion
The tech left me 2 messages as well, but I was not here. I was going to take the job, but I could not touch base. Then, the new recruiter (they just changed their HR department) contacted me and we worked things out. She e mailed me all the forms, which maybe you need now. If you want the job, just go ahead and call and ask for the new recruiter.. I am sure they will put you through. Good Luck, it will all work out!
No - it was not yours. Sorry for the confusion.
Must have been deleted. Sorry for the confusion, it does look like I was talking to you, but I wasn't ;-)
Sorry for confusion!
I worked for KS at home on Son's XP because the account (acute care not radiology) required it as Vista was not compatible. It was a Clinic in Ohio. Since I'm in the office at a major hospital I cannot work FT for KS.
MQ packet confusion
I also live in NE and I have not received my PACKET let alone the pre-packet phone call. What is going on here?
Confusion..TT/exText???sm
Now it seems there are a lot of good postings regarding TT..but what is this about the deduction for headers/footers? Is that a TT thing. I have applied to TT (not heard back yet) but I have never seen a co. deduct for head/footers....this seems quite unreasonable...it should either be included in the count or not...now I'm scared. Please clear this up if you can.
Sorry bout the confusion -- DSG-- nm
nm
My bad - not Allstate - sorry for confusion.
I'm breaking my fingers now, lol.
Not confusion to me - I like the variety
No confusion to those of us that actually read the post!
Thanks for clarification :-)
New to Transcend, holiday confusion. sm
Am I expected to either work Thanksgiving or Christmas and do not automatically get these holidays off? I am not able to get the lines to qualify for PTO, and so do not care about not getting holiday pay, but I am now wondering whether I even get these 2 holidays off. TIA!
I would leave MQ off, there has been a big change in the last few months. Too much confusion. nm
nm
Correction
What determines their line? I am stressed these days. Thanks.
Correction
Sorry, title should read I Believe That...
Correction
Re: Why would anyone be WILLing to slave over this work for 27-YEAR-OLD wages?
Actually would be correct to have just said regressive wages...
Correction
this isn't clear:
The corporations call the shots with YOUR Congress/government primarily because AMERICANS are so easily pacified and distracted by the toys these corporations made for that exact purpose.
They (corporations) call the shots because of their influence; and CONGRESS helped to give them that power in the late 1800s by passing certain laws which gave the corp. similar rights to individuals...
I mixed two thoughts originally...
Correction - sorry
feedback on that PROGRAM (i.e. Isagenix), not problem.
rad pay correction
I need to clarify this was only for emergency coverage and is temporary. My supervisor informs me that once we go to VR, only 2 inhouse full-time transcriptionists will be used and those positions are filled.
correction
meant same nonexistent or uncommon email service provider
Correction
Worked for them in mid 90s, not 80s....it's been a long day!
correction
let you go that should read.
Correction
80% + ESL account
Correction
Whoops! I meant places, not placed.....
Correction...Not 12 cpl...
You'd have to make between 10.72 and 10.1 cpl for straight typing to make 7.5 cpl for ISR at Webmedx. I don't think a relative newbie with only 5 years experience is making over 8.5 cpl starting with Webmedx. Correct me if I'm wrong. I just don't believe it for a minute.
Just a correction...sm
your base rate is NOT $9....it is based on YOUR line rate, so for everyone it is different. I actually get quite a bit more than that. Also, Medware has more than one platform, so what is happening on the Dictaphone side is NOT necessarily happening on the Merit side, and not everyone is unhappy on the Dictaphone side. Not THAT many have left. Just so you know and can make an informed decision.
Correction.
Completely different atmosphere on CMX side.
Correction
Whoops, I meant to say I HOPE, not I CAN. It's way late where I am, so I had best pack it in for the night. Sorry for the error.
Correction: Above should be "...NO announcement..." NM
..
Correction to post - sm
I have also seen positive and negative things mentioned about virtually every transcription company discussed on this web site. Didn't mean to say companies that YOU discussed on this web site!!
Correction; PSYCHIATRIST
NM
OSI - I am so sorry - PLEASE NOTE CORRECTION
Note correction in CAPS
If you do control S for a job and click on statistics you will get a number of lines. If you are on OSI's very own line cheating Xpress server, that number will be much HIGHER (NOT LOWER) than the IChart line count. Do this. Do only one job for the day then write down the correct line count using the above method. Go to IChart although it may take hours to show up so you may want to do this on a day off. There is your proof. I-CHART LINES ARE LOWER THAN OSi X-PRESS LINES. The reason the correct statistics are disabled on the XPress server is because OSi is skimming lines and don't want you to see the correct number. OSI is diligently trying to eventually get every possible account on their very own XPress server so they can cheat on all accounts. Rest assured that they are billing the client for the correct line count. I could not make any money with OSI because of their dishonesty. Dictaphone Extext is a good system but OSI could change how it was set up and rip the MT's off.
Holidays correction
I'm sorry the above poster is right. If you want off you have to take it without pay or use PTO. You get paid extra if you work the holiday...which to me is a bonus as so many don't pay anything extra for holidays. Sorry for the confusion.
Whose QA gets paid per correction?
We get paid hourly, although I do know there are some who get paid per line. The folks I know paid per line get credit for the full report, not just their corrections. They also are the first blamed if a client reports an error in a report that has passed through QA.
Correction - "a few WORDS"....
nm
Correction **4.5-5.5 cpl VR** not MR. Please excuse
Ty.
correction to first post
Oops--I know ISDN is a location-to-location thing so that's out as far as working for a national. I recall a while back that several MTs mentioned they worked for nationals using hughes.net/satellite. Thanks again for any info.
correction low not lowl
slip of the finger
CORRECTION - not post right above, the mean one
xxx
Correction to my above post. I just looked
and I apologize. I had to wait until the 1st of the next month, not the 15th (maybe it just seemed longer) for that money to be in the bank. So for that payroll from the 1st until the 15th, I had to wait until the 1st (though the payroll was late). Guess all the waiting just seemed longer. That still is the longest I have had to wait for a payday. So when I quit, I also had the same thing. I just went through the paperwork.
In any event it SEEMED like a very long time and particularly with some of the paydays being late.
I do apologize as I certainly do not like to give incorrect info.
When you have kids though it does hurt. In other words, I started on the 1st of the month and first paycheck was not until the 1st of the next month except it was late.
Correction: Don't get all excited now...they are NOT paying at least 8 cpl.
Correction: Should NOT expect to be paid
x
correction to thin-skinned
I meant I don't really THINK that is necessary...
Oops-correction, s/b learned!
Need more coffee! 
oops, correction, spoke too soon -- sm
OSi does not appear to offer health insurance, etc. on their website ... they do offer holiday pay and other nice things ...
Correction to Minnie Mouse
Whoops, I meant to say lowly MT, not lowly MD. (That wouldn't be me, I hated science.) I was up nearly all night last night working. No work shortage here. Anyway, sorry I made an error in typing, hope the grammar/typing cops don't launch their grenades at me. :)
|
