I have to put that leading 0 and use h:mm:ss format
Posted By: tnmt on 2008-01-26
In Reply to: Excel date/time value vs. format - Excel guru
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. :)
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
Not a leading question, I was emailed this info
NM
there was a lot of 'out of work' comments long before and leading up to any - sm
negativity, which, I might add, seem to excalate as the baren dayes turned into months.
my experience on this site.
Okay.. you have a point.. isnt that the "blind leading the blind." Maybe 1.5 cpl is appropria
THINGS THAT MAKE YA GO HMMMMMMM
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 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
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....
I totally agree re medical report format.
x
Anyone know of a company, easy clinic work, easy Word format, dependable pay? Help!
x
Blind leading the blind, but here goes...
At the very top, where it says, file, then edit, there will be view. Click on view. Click on toolbar. Play around with adding and deleting toolbars until you get the one(s) you want.
Good luck!
this may be the blind leading the blind, but...
I think it is control F3, then I think what you want is under local configuration. How quickly we forget this stuff, geez!!
|
