I'm trying to set up an Excel Work Sheet to keep records of my Work History. Column Headings being: Date, Day, In (time started working), Out (time broke form lunch), In (time went back to work after lunch), Out (time quit for the day), Total Hours (total hours in formula =(Out A - In A) + (Out B - In
), Wages, Description of Work Done.
I get how to make the times "a" for AM and "p" for PM. I got a simple formula for calculating the hours worked: "=(Out A - In A) + (Out B - In
)". Only how do I get the hours worked to be expressed in a disciple number with "hrs" behind it as the label. I don't want 4:30 AM under Total Hours (in the hours worked column) when it should be "4.5 Hrs". Anyone?
Then what is the formula for wages, to take the hours worked times dollars per hour to calculate the wages from this and presented as a dollor "$" amount not just a number? Please?
I'm sure I should be able to find how to use spell check for the next column where I enter the description of what I've done but just in case how would I set spell check up for discription?
That should cover what questions I have so far and if I can get an answer to just these I'll consider it a lot. Then I'll return I'm sure for the questions that I'll have once I get this done. But first things first. Anyone that can help me with these few questions will be a life saver. I have about 8 months of work data to put to this excel once I get it set up. So anyone that can help would be greatly appreciated. Thank you.
And H A P P Y H O L I D A Y S !